Forum Discussion
Karolina411
Helper V
2 years agoparameter duplicates in Report Builder for Paginated Reports.
I have a Paginated Report (I am using a tabular model from our analysis server) question as I have 2 datasets joined by a common Parameter which is the DateColumn MonthYear- I have these referenced i...
- 2 years ago
Try this as your dataset2
EVALUATE SUMMARIZECOLUMNS( 'Providers'[PhysicianOrganization], FILTER( 'DateDim', 'DateDim'[YearMonth] = @YearMonth ) ) - 2 years ago
If the duplication is due to multiple rows in the dataset having the same PhysicianOrganization value, consider adding a DISTINCT clause directly in the DAX query or in the SQL query that gets the data.
Ensure that the slicer displays only distinct values. You can modify the DAX query to return distinct PhysicianOrganization values. For example, you can wrap your SUMMARIZECOLUMNS function with the following DISTINCT function:EVALUATE DISTINCT( SUMMARIZECOLUMNS( 'DateDim'[YearMonth], 'Providers'[PhysicianOrganization] ) )hackcrr
If I have answered your question, please mark my reply as solution and kudos to this post, thank you!
aduguid
Memorable Member
2 years agoTry this as your dataset2
EVALUATE
SUMMARIZECOLUMNS(
'Providers'[PhysicianOrganization],
FILTER(
'DateDim',
'DateDim'[YearMonth] = @YearMonth
)
)