Forum Discussion
Count text value appearances across whole table
Hi all, Many thanks in advance for the help! I'm trying to count all appearances of text across a whole table, and get a total count of appearances. I'm aware there's no straight SUMIF in Power B...
Hi Anonymous
You can best unpivot the finisher columns first (in PQ), then build a very simple measure. You can also use a slicer to choose if you want to see only fist finishers, 1st and 2nd , all finishers, etc.
See it all at work in the attached file.
Please mark the question solved when done and consider giving a thumbs up if posts are helpful.
Contact me privately for support with any larger-scale BI needs, tutoring, etc.
Cheers
Thanks both - managed the (very simple) unpivot as described by AlB - but thanks so much for the help both!