Forum Discussion
Percentage formula
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.
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.
2 Replies
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.
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.
