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

Join us for an expert-led overview of the tools and concepts you'll need to become a Certified Power BI Data Analyst and pass exam PL-300. Register now.

Reply
kattlees
Post Patron
Post Patron

Count values from multiple columns into one.

I am trying to get a headcount of employees in a matrix. Each employee is assigned a "class" based on full time hourly, full time salary, PRN, or how part time.  How do I get the columns to show the count of a combination of classes so all full time are counted together and all prn and all part time? See below - the big one is what I am pulling (by class) and the small inset one is what I am trying to accomplish.

Matrix-Sample.jpg

1 ACCEPTED SOLUTION

I created a new column and grouped the classes by using =LEFT(Fieldname, # of characters) and it worked.

View solution in original post

4 REPLIES 4
haozhong
Resolver I
Resolver I

To make things easier, if you are pulling data, pull them in a flat table in excel then add additional column to group them class 1, class 2 etc in excel using a separate lookup table.

 

Then use power BI to read it

 

 

 

 

Not following the pulling them into a flat table in excel?   We pull directly from an sql database. I have added new columns to combine first and last name, etc. Just can't figure out the counts.

Flat table as in

 

RN | Class 1A 8833 | Class 1 | 2 |

RN | Class 3 8833 | Class 3 | 1 |

 

Easier to count that way in power BI or pivot tables in excel

 

just my opinion

 

 

I created a new column and grouped the classes by using =LEFT(Fieldname, # of characters) and it worked.

Helpful resources

Announcements
Join our Fabric User Panel

Join our Fabric User Panel

This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.

June 2025 Power BI Update Carousel

Power BI Monthly Update - June 2025

Check out the June 2025 Power BI update to learn about new features.

June 2025 community update carousel

Fabric Community Update - June 2025

Find out what's new and trending in the Fabric community.