If there are multiple columns like sales, orders. Then how do make all these columns as filter. The value in the table should change to selected metric from the filter

[Aditya_Raj]

I have data at a date level. and have measures like sales, orders, cogs all numerical. I want to create a filter which should have all the measures in a filter. whenever one is selected the table is populated with that measure

[Max]

Are you saying, for instance, if you select sales you would only see sales in your table?

You can use this with parameters & calculated fields.

Create a parameter called “measure” and then you’ll need to select a default value. You can say sales.

Then create a calculated field called measure.

ifelse(${Measure}=‘sales’,{sales},${Measure}=‘orders’,{orders},{cogs})

Then you can use this in a table.