Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
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.
Solved! Go to Solution.
I created a new column and grouped the classes by using =LEFT(Fieldname, # of characters) and it worked.
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.
Check out the July 2025 Power BI update to learn about new features.
This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.
User | Count |
---|---|
63 | |
63 | |
53 | |
39 | |
25 |
User | Count |
---|---|
85 | |
57 | |
45 | |
43 | |
38 |