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