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

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