Forum Discussion
Total percentage column
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
Hi All,
I have managed to solve it!!! Created the following measure:
Total % =
DIVIDE(
SUM('Car'[Charged]),
SUM('Car'[Invoiced])
)
3 Replies
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.
Hi,
Show your source data.
Hi All,
I have managed to solve it!!! Created the following measure:
Total % =
DIVIDE(
SUM('Car'[Charged]),
SUM('Car'[Invoiced])
)
