Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Score big with last-minute savings on the final tickets to FabCon Vienna. Secure your discount

Reply
Anonymous
Not applicable

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)?

 

Jess90_0-1635888600924.png

Query:

// DAX Query

DEFINE

  VAR __DS0Core =

    SELECTCOLUMNS(

      KEEPFILTERS(

        FILTER(

          KEEPFILTERS(

            SUMMARIZECOLUMNS(

              'DimLocation'[Country],

              'Action'[Control],

              "CountRowsFactAction", CALCULATE(COUNTROWS('Action'))

            )

          ),

          OR(

            NOT(ISBLANK('DimLocation'[Country])),

            NOT(ISBLANK('Action'[Control]))

          )

        )

      ),

      "'DimLocation'[Country]", 'DimLocation'[Country],

      "'FactAction'[Control]", 'Action'[Control]

    )

 

  VAR __DS0PrimaryWindowed =

    TOPN(501, __DS0Core, 'DimLocation'[Country], 1, 'Action'[Control], 1)

 

EVALUATE

  __DS0PrimaryWindowed

 

ORDER BY

  'DimLocation'[Country], 'Action'[Control]

 

My question: How can I create a parameter if I use this query? How to write a DAX code included in this query to create a parameter in paginated report? 

1 ACCEPTED SOLUTION
AlexisOlson
Super User
Super User

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

View solution in original post

3 REPLIES 3
Anonymous
Not applicable

@AlexisOlson thanks for the quick solution.

AlexisOlson
Super User
Super User

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

Anonymous
Not applicable

@AlexisOlson thanks for the quick solution. 

Helpful resources

Announcements
August Power BI Update Carousel

Power BI Monthly Update - August 2025

Check out the August 2025 Power BI update to learn about new features.

August 2025 community update carousel

Fabric Community Update - August 2025

Find out what's new and trending in the Fabric community.