How to Calculate the Total Percentage and for each job level?

[Murtadhaay]

Hello,

I need your help in how to calculate:

1- %qualified employees over the total employee

2- %Qualified for each job level like we have 2 Associates and one of them is qualified so it should show %50 but how can I do that in power bi?

I tried filter, index column and lookup functions DXA but unfortunately I couldn't get a result!

[MohammadLoran25 · Accepted solution]

Hi

Define Below Measures:

1-

ALLPersons =
CALCULATE (
    COUNTROWS ( VALUES ( JobLevelStatus[Name] ) ),
    ALL ( JobLevelStatus )
)

-------------------------------

2-

JobtitlePersonsCount =
CALCULATE (
    COUNTROWS ( VALUES ( JobLevelStatus[Name] ) ),
    SUMMARIZE ( JobLevelStatus, JobLevelStatus[JobTitle] )
)

--------------------------------------

3-

QualifiedPersons =
CALCULATE (
    COUNTROWS ( VALUES ( JobLevelStatus[Name] ) ),
    JobLevelStatus[Status] = "Qualified"
)

Then to achieve your first question answe: DIVIDE([QualifiedPersons],[Allpersons])

And 

to achieve your second question answer: DIVIDE([QualifiedPersons],[JobTitlepersonsCount])

Actually the only trick is that you have to do the "group by" over JobTitle to only count the persons of each jobtitle separately and then do the division in your second case.

Best Regards,

Loran

[Murtadhaay]

Thanks a lot Loran

This first question is okay and I got the results like 0.50 how to convert it as percentage?
The second one I tried to group by but all the visiuals effected, any other way to do it?

[MohammadLoran25]

You're welcome.

To get it in percentage format, just select your measure in power bi, then go to the "Measure Tools" tab in the upper ribbon, and then change the format to "Percentage".

Sorry but what do you mean that all your visuals are affected? This measure works for what you wanted. Please explain more with examples if there is any problem with that.

Thanks.