Forum Discussion

Markzolotoy's avatar
Markzolotoy
Impactful Individual
5 years ago

Paginated report parameter in DAX

If I have this expression: COUNT(Table1[Field1]) Can use a report parameter n a place of a table name? Something like this: COUNT(@parameter_TableName[Field1])   Thanks
Need Help
bradsy's avatar
bradsy
Microsoft Employee
5 years ago

Write your query, then edit the dataset(right click in the left side dataset section where your dataset is). There is an expression button next to the query, can see in picture.

Markzolotoy's avatar
Markzolotoy
Impactful Individual
5 years ago

Here is my test code:

="EVALUATE
CALCULATETABLE(

SUMMARIZECOLUMNS(
"High_Count", CALCULATE(COUNT(" & "FilteredTable1" & "[Severity]),FilteredTable1[Severity]="High"),
"Informational_Count", CALCULATE(COUNT(FilteredTable1[Severity]),FilteredTable1[Severity]="Informational"),
"Low_Count", CALCULATE(COUNT(FilteredTable1[Severity]),FilteredTable1[Severity]="Low"),
"Medium_Count", CALCULATE(COUNT(FilteredTable1[Severity]),FilteredTable1[Severity]="Medium")
)
)"

 

Error:

[BC30205] End of statement expected.