Forum Discussion

Markzolotoy's avatar
Markzolotoy
Icon for Impactful Individual rankImpactful 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
Icon for Microsoft Employee rankMicrosoft Employee
5 years ago

It takes a bit of finageling, but you can probably get it to work. A very simple expression example for a SQL query. ="Select * from " & Parameters!Customers.Value

 

Yours might be more like ="COUNT(" & Parameters.parameter_TableName.Value + "[Field1])"

 

 

Markzolotoy's avatar
Markzolotoy
Icon for Impactful Individual rankImpactful Individual
5 years ago

this is not working

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

  • bradsy's avatar
    bradsy
    Icon for Microsoft Employee rankMicrosoft 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
      Icon for Microsoft Employee rankMicrosoft 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
        Icon for Impactful Individual rankImpactful Individual
        5 years ago

        So, the expression would be something like this:

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