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

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:

 fordjagmercbmwTotal
Invoiced10234294119763361
Charged9832189419843297
%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])
            )

 

View solution in original post


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,

 

 

Show your source data.

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])
            )