Forum Discussion
Anonymous
4 years agoNot 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)? Query: // DAX Query DEFINE VAR __DS0Core = SELECTCOLUMNS(...
- 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
Anonymous
4 years agoNot applicable
AlexisOlson thanks for the quick solution.