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.
Hi All,
Need help with percentages in a total column. I have the folloing table but I can't seem to get the percentages to add up. the table looks as follows:
ford | jag | merc | bmw | Total | |
Invoiced | 102 | 342 | 941 | 1976 | 3361 |
Charged | 98 | 321 | 894 | 1984 | 3297 |
% | 96% | 94% | 95% | 100% | 96% |
The total percentage needs to be 3297/3361 which should give and answer of 98% but its just doing an average of all the other percentages in the row!!
Thanks
Bilal
Solved! Go to Solution.
Hi All,
I have managed to solve it!!! Created the following measure:
Total % =
DIVIDE(
SUM('Car'[Charged]),
SUM('Car'[Invoiced])
)
Hi All,
I have managed to solve it!!! Created the following measure:
Total % =
DIVIDE(
SUM('Car'[Charged]),
SUM('Car'[Invoiced])
)
Hi,
Show your source data.
Can you share your calculations with us? Or the names of your fields so we can share some with you? Maybe a snip of your data?
It appears that if you have the calculations you should put your vehicle make in the row and then put your measures as values. that might help to get the totals correct.
Proud to be a Super User!
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 |
---|---|
113 | |
97 | |
84 | |
67 | |
60 |
User | Count |
---|---|
150 | |
120 | |
99 | |
87 | |
68 |