1 of 1 people found this helpful
You could probably build something like this with five calculated fields but it seems like using measure names as a filter would make more sense.
WHEN 'All' THEN
WHEN 'Sales' THEN
WHEN 'All' THEN [Profit]
WHEN 'Profit' then [Profit]
Using Measure names provides a cleaner look
Brilliant answer by ivan.yong
I was thinking of a different way-
[Measure1] + '|' + [Measure2] + '|' + [Measure3] + '|' + [Measure4] + '|' + [MeasureN] /* using | as delimiter */
and then seperating the measures by spliting from delimiters. If a single meaure was choosen remaining fields would automatically stay Null.
Very Interesting, I think you will need to convert you measures to STR in order to avoid type mismatch when adding your delimiter. Then convert back to a number after splitting if you want to aggregate. Too much work for me, but if you mock something up please share. I would pursue a measure names single select dropdown first as it seems clean and easy.