Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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]
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
114 | |
100 | |
75 | |
73 | |
49 |
User | Count |
---|---|
145 | |
109 | |
109 | |
90 | |
64 |