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