
Hi,
I have a attached workbook with several measures, labeled "16F", "16M" etc.
I've build a filter, if ALL of the measures are higher than a specific value x and this works fine.
But now, I would like to have a filter like "If more than y measures are higher than x" and I don't know, how to do this. I mean, I could build a filter with all combinations, but I have 10 measures and this would become a hazzle. Therefore, is there an easier solution?
Kind regards and thank you very much,
Ralf
4 answers
Hello Ralf,
Please pivot first, then the calculation becomes easy.
Pivot Data from Columns to Rows - Tableau
The sample workbook is attached.
Regards
Lei