cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Bilal_321321 Regular Visitor
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:

 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

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
Bilal_321321 Regular Visitor
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
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.



Did I answer your question? Mark my post as a solution!

Proud to be a Datanaut!




Super User
Super User

Re: Total percentage column

Hi,

 

 

Show your source data.

Highlighted
Bilal_321321 Regular Visitor
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])
            )