Microsoft Fabric Community Conference 2025, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount.
Register nowThe Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.
Please help in solving one problem. You need to calculate the percentage as the ratio of [delta plan] and [plan]. Tried different options but have not yet found solutions.
Hi @Lexey,
What you want to calculate is 2198/3548=0.6195 for the first row under [delta % plan], right?
If so, you should modify the measure [delta % plan] as below:
delta % plan = [delta plan]/ [Values of budget]
Best regards,
Yuliana Gu
I need row context.,
1 row = [delta plan]/[Values of budget]
2 row = [delta plan]/[Values of budget]
3 row = [delta plan]/[Values of budget]
you get a total percentage that doesn't suit me. Thanks
You could try SUMX(Table;[delta plan]/[Values of budget].
This is for a Measure.
Calculated Column would just be [delta plan]/[Values of budget]
I'm not quite sure wether your columns is name Values of budget or plan.
Please try and let me know.
Thanks
I didn't get quite the right result
delta % plan = sumx('fact'; [delta plan]/ [Values of budget])
What would be your expected results?
For the total row I see it makes no sense.
You may have to change to delta % plan = sum([delta plan]/sum[Values of budget]
User | Count |
---|---|
120 | |
65 | |
62 | |
56 | |
50 |
User | Count |
---|---|
177 | |
85 | |
70 | |
63 | |
55 |