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
Markzolotoy's avatar
Markzolotoy
Impactful Individual
5 years ago

this is not working

CALCULATE(COUNT(Parameters.tablename.Value[field]). Its' not even running

bradsy's avatar
bradsy
Microsoft Employee
5 years ago

It will not run in the query designer, only as an expression as your dataset. The syntax needs to be ="COUNT(" & Parameters.parameter_TableName.Value & "[Field1])" similar to shown in the picture.

  • 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

      So, the expression would be something like this:

       ="EVALUATE COUNT(" & Parameters.parameter_TableName.Value & "[Field1])" 

    • 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.