Forum Discussion

Karolina411's avatar
Karolina411
Icon for Helper V rankHelper V
2 years ago
Solved

parameter 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...
  • aduguid's avatar
    2 years ago

    Try this as your dataset2

     

    EVALUATE 
    SUMMARIZECOLUMNS(
        'Providers'[PhysicianOrganization],
        FILTER(
            'DateDim',
            'DateDim'[YearMonth] = @YearMonth
        )
    )

     

  • hackcrr's avatar
    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!