Counting Text across multiple columns

[AA364]

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

[amitchandak]

@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

https://radacad.com/userelationship-or-role-playing-dimension-dealing-with-inactive-relationships-in...