Let's say I have a table with four columns - Year, Organisation, Sales, Cost.
I want to create a slicer with two values - Sales and Cost, and an option to select only one of those.
If Sales value is selected from the slicer then I want my metric to display sum(Sales), if Cost is selected then I want sum(Cost).
Also, I'd like to use this metric to aggregate on Year/Organisation. Is this possible?
Best answer by Michael UllockView original