Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Grow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.

Reply
AA364
Regular Visitor

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 1
amitchandak
Super User
Super User

@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...

Helpful resources

Announcements
RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

MayPowerBICarousel

Power BI Monthly Update - May 2024

Check out the May 2024 Power BI update to learn about new features.