Total percentage column

[Bilal_321321]

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

[Bilal_321321 · Accepted solution]

Hi All,

I have managed to solve it!!! Created the following measure:

Total % = 

DIVIDE(
             SUM('Car'[Charged]),
             SUM('Car'[Invoiced])
            )

[Ashish_Mathur]

Hi,

Show your source data.

[kcantor]

@Bilal_321321

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.