dax duplicates
1 Topicparameter 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 inside both datasets like so: (dataset1 uses both parameters for filtering but I want dataset2 to only use the date filter) Dataset1 has YearMonth and PhysicianOrg parameters but Dataset2 only has YearMonth as we do not need the PhysicianOrg parameter for Dataset2. I have a total of 3 datasets from the same source. My Parameter ‘physician organization’ is creating duplicates in the slicer when I view the report. Any way to solve this? Here is the dax and and the values are from the 2nd table but the parameter is referenced in DataSet1. EVALUATE SUMMARIZECOLUMNS('DateDim'[YearMonth], 'Providers'[PhysicianOrganization])Solved1.8KViews0likes2Comments