Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

Paginated report dataset from Power BI DAX query

Hello,   Is there anyone who created a datset in Paginated report using Power BI Dax query (from Performance Analyzer)?   Query: // DAX Query DEFINE   VAR __DS0Core =     SELECTCOLUMNS(...
  • AlexisOlson's avatar
    4 years ago

    Use the @ symbol for a parameter and make sure it's mapped in the parameters section.

     

    Here's a simplified example based on your query:

    DEFINE
        VAR CountryFilter = TREATAS ( { @Country }, 'DimLocation'[Country] )
    EVALUATE
    SUMMARIZECOLUMNS (
        'DimLocation'[Country],
        'Action'[Control],
        CountryFilter,
        "CountRowsFactAction", CALCULATE ( COUNTROWS ( 'Action' ) )
    )
    

     

    More detail in my answer here: https://stackoverflow.com/questions/68820105