topic Re: Paginated report dataset from Power BI DAX query in Developer

Paginated report dataset from Power BI DAX query

Anonymous — Tue, 02 Nov 2021 21:35:42 GMT

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(

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?

Re: Paginated report dataset from Power BI DAX query

AlexisOlson — Tue, 02 Nov 2021 21:59:40 GMT

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

Re: Paginated report dataset from Power BI DAX query

Anonymous — Wed, 03 Nov 2021 12:38:59 GMT

@AlexisOlson thanks for the quick solution.

Re: Paginated report dataset from Power BI DAX query

Anonymous — Wed, 03 Nov 2021 12:39:30 GMT

@AlexisOlson thanks for the quick solution.