Percentage formula

[ch_01]

Hi, 

I need to calculate percentage promoted people according to Gender from total employees, 
( Columns: Total Employees, Gender, Hire (1/0 as values), Hire percentage) when I try to calculate percentage for Hire its giving me 100% as results for both genders. 

 I'm pretty new to Power BI so looking for some help.

[v-zhangti · Accepted solution]

Hi, @ch_01 

You can try the following methods.
Measure:

Percentage = 
Var _N1=CALCULATE(COUNT('Table'[Gender]),FILTER(ALL('Table'),
                        [Gender]=SELECTEDVALUE('Table'[Gender])&&[Promotion 2021]=1))
Var _N2=CALCULATE(COUNT('Table'[Gender]),ALL('Table'))
Return
DIVIDE(_N1,_N2)

Please check the attachment, I hope it can help you.

Best Regards,

Community Support Team _Charlotte

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[lin_k]

Hi ch_01,

my advice is that you continue and load your Data. Then do the calculations afterwards. A good way would be to use the DAX-Quickmeasures (https://learn.microsoft.com/en-us/power-bi/transform-model/desktop-quick-measures), here you can do division, percentage calculation etc. more easy than writing a M-Query. I hope this helps.