Forum Discussion
Markzolotoy
5 years agoImpactful Individual
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
bradsy
5 years agoMicrosoft Employee
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
5 years agoImpactful Individual
Ah, I see my mistake. Where would I build that expression?