Calculating Correct Totals on Percentage Column in Table

[Roseventura]

Hi there.

I'm have a problem that is similar to this issue:

                   http://community.powerbi.com/t5/Desktop/Totals-on-Percentages-in-Tables/m-p/53088

The solution in this issue was to use a measure.  However, I'm using a measure and it's still not calculating the correct total.  The correct % total should be 28.6%.

Here is my table:

My measure is this:

FCST GP % by Div =
CALCULATE (
    SUM ( PBI_NICBudget_Multi[FCST GP%] ),
    USERELATIONSHIP ( Company[Company], PBI_NICBudget_Multi[COMPANY] )
)

Should I be using a DAX formula OTHER than SUM() for percentages? 

NOTE:  I renamed the heading in the table, from "FCST GP % by Div" to "FCST GP %" to simplify it.

Thanks,  Rose

[Ashish_Mathur]

Hi @Roseventura,

Share the link from where i can download your file.

[Roseventura · Accepted solution]

I discovered what was wrong:

The field FCST GP% is in the fact table.  By using this field instead of creating a measure that produces the same result, it will always SUM at the bottom as Phil mentioned above.

I solved this by NOT using that field and creating a new measure that calculates the Forecast GP% (FCST GP$ / FCST $).  This calculated the percentage and also displays the correct percentage at the bottom.

 

[Phil_Seamark]

HI @Roseventura

It looks like your total is doing exactly what your formula is asking it to do, to simply SUM the values above it.

How do you arrive at the result for your percentage?  Do you have a calculation somewhere else that does a division to produce the 28.6%