Forum Discussion
Counting Text across multiple columns
I'm pretty new to Power Bi - I have a data set that contains multiple strengths (ie strength 1, strength 2, strength 3 etc) along with other columns (name, function, etc). The strengths are from a set list of 34 possible words - I'm trying to create a visual to see the count of each word across all strength columns. Is that possible? Does this even make sense - in excel I would use the COUNTIF function and link it back to the strength and create a new table - but I'm struggling with doing the same in Power Bi
1 Reply
AA364 , One is you can unpivot all the columns in power query and then you will all strength in rows with their name
https://radacad.com/pivot-and-unpivot-with-power-bi
Another join a strength dimension to all strength columns, You will have 1 active and the rest inactive join. Use userelationship to create count measures
