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

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
DeniseDL
Regular Visitor

Get total of classifications with different levels of that classification

Good morning,

 

I have a calculation I want to make, but I seem to missing how to do it.  I am very new to Power BI.  

 

I have a table with a column "Classification" that has several employee classification at various levels. i.e.: BI 01, BI 02...; EG 01, EG 02...

 

I would like to get a total number of employees in each classification.  I'm not sure how to get Power BI to calculate a total of, say 'BI's or 'EG's by summing up all the levels and giving me one total for the whole classification.  There are too many classifications and levels for to just filter each one.

 

DeniseDL_0-1684500070698.png

Any help would be greatly appreciated!

 

Thank you!

1 ACCEPTED SOLUTION

Sure!

 

Open Power Query to transform a little bit your data. First you can duplicate your "Classification" column. Then use the following option:

 

Alf94_1-1684511108160.png

 

It will create two new columns:

 

Alf94_2-1684511172862.png

 

Use the "Close and Apply" button. Now your table looks like this:

 

Alf94_3-1684511290292.png

 

You can finally create the visual as expected:

 

Alf94_4-1684511333163.png

 

If I answered your question, please mark my post as a solution.

Best,

View solution in original post

5 REPLIES 5
Alf94
Super User
Super User

Hi @DeniseDL,

 

I worked with this sample:

 

Alf94_0-1684500729300.png

 

You can try this type of visual to solve your problem:

 

Alf94_1-1684500772628.png

 

If I answered your question, please mark my post as a solution.

 

Best

That is great, however, we have a ton of classifications and levels that the visual would never be big enough.  That is why I want to sum up all the level in the classification to show just the classification total.

 

i.e.: there are 1550 BI's out of 16000 employees

@DeniseDL,

 

Is it what you are looking for?

 

Alf94_0-1684502059283.png

 

If yes, I used Power Query to extract text before delimeter (which is a space here) and obtain a new column with only AS/EG/CR. Then you can create the visual.

 

If I answered your question, please mark my post as a solution.

 

Best,

 

Yes!  That is what I'm looking for.  However, I'm not sure I understand how you got there.  Would you be able to expand on your explanation?

Sure!

 

Open Power Query to transform a little bit your data. First you can duplicate your "Classification" column. Then use the following option:

 

Alf94_1-1684511108160.png

 

It will create two new columns:

 

Alf94_2-1684511172862.png

 

Use the "Close and Apply" button. Now your table looks like this:

 

Alf94_3-1684511290292.png

 

You can finally create the visual as expected:

 

Alf94_4-1684511333163.png

 

If I answered your question, please mark my post as a solution.

Best,

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

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

Top Solution Authors