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

Yes you should be able too if your query is also an expression.

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

Yes, it is a DAX expression that is created in the Design mode. Is that what you are saying?

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

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

      Ah, I see my mistake. Where would I build that expression?