## Desktop

Highlighted
Regular Visitor
Posts: 21
Registered: ‎06-14-2017

# 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

Accepted Solutions
Regular Visitor
Posts: 21
Registered: ‎06-14-2017

## Re: Total percentage column

Hi All,

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

Total % =

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

All Replies
Super User
Posts: 756
Registered: ‎08-27-2015

## Re: Total percentage column

@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.

Super User
Posts: 4,103
Registered: ‎01-14-2017

## Re: Total percentage column

Hi,

Regular Visitor
Posts: 21
Registered: ‎06-14-2017

## Re: Total percentage column

Hi All,

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

Total % =

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