Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Hi, I'm new in Power BI. Need some guidance to solve below issue.
I unable to show percentage value for each year. Can you guys help me to get the value?
Example calculation for Year 2022:
Female: 20/(20+12)x100% = 62.5%
Male: 12/(20+12)x100%=37.5%
I also need to show the value percentage in line chart as in picture above.
Thank you so much.
Solved! Go to Solution.
Hi @nunamhmd7 ,
I created some data:
Here are the steps you can follow:
1. Create measure.
Measure =
var _all=SUMX(FILTER(ALL('Table'),'Table'[Year]=MAX('Table'[Year])),[Value])
var _gender=SUMX(FILTER(ALL('Table'),'Table'[Year]=MAX('Table'[Year])&&'Table'[Gender]=MAX('Table'[Gender])),[Value])
return
DIVIDE(_gender,_all)
2. Select [Measure] – Measure tools -- %.
3. Result:
Best Regards,
Liu Yang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly
Hi @nunamhmd7 ,
I created some data:
Here are the steps you can follow:
1. Create measure.
Measure =
var _all=SUMX(FILTER(ALL('Table'),'Table'[Year]=MAX('Table'[Year])),[Value])
var _gender=SUMX(FILTER(ALL('Table'),'Table'[Year]=MAX('Table'[Year])&&'Table'[Gender]=MAX('Table'[Gender])),[Value])
return
DIVIDE(_gender,_all)
2. Select [Measure] – Measure tools -- %.
3. Result:
Best Regards,
Liu Yang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly
Hi thanks for your help. I manage to get it! It helps a lot
Hi @nunamhmd7
You need to show a sample of your tables with the relevant fields and the code for the measures yo are currently using in the charts you show above
|
Please accept the solution when done and consider giving a thumbs up if posts are helpful. Contact me privately for support with any larger-scale BI needs, tutoring, etc. |
User | Count |
---|---|
140 | |
113 | |
104 | |
77 | |
65 |
User | Count |
---|---|
135 | |
116 | |
101 | |
71 | |
61 |