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

      • 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

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