cancel
Showing results for
Did you mean:
Regular Visitor

## 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

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
Regular Visitor

## Re: Total percentage column

Hi All,

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

Total % =

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

3 REPLIES 3
Super User

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

Proud to be a Datanaut!

Super User

Hi,

Highlighted
Regular Visitor

## Re: Total percentage column

Hi All,

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

Total % =

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