PowerBI Desktop Sum Values, Grand Total

[nniphadk]

I am trying to get grand totals at the bottom of Category 1 in PowerBI, so far I have been unsuccessful. Can someone point the error out

Category 1 = If(%Salary/Desired Salary < .90, Difference, 0)

It does not give me a total of -30,000. I would want to know what the total difference is going to be

[TaylorPBI21 · Accepted solution]

Hi @nniphadk,

I done this using 2 measures and a calculated column give this a try...😎

2 measures

Difference = SUMX('Table A', 'Table A'[Salary] - 'Table A'[Desired Salary])

% Difference = SUMX('Table A', 'Table A'[Salary]/'Table A'[Desired Salary])

Calculated column

Difference < 90 = SWITCH(
    TRUE(),
    [% Difference] < 0.90, [Difference],
    0
)

If @Len_Barr solution doesn't work give this a bash...

Many thanks,

Taylor 😊

[nniphadk]

Circular dependency was detected

[TaylorPBI21]

Hi @nniphadk ,

It needs to be laid out with the 2 measures and the 1 calculated column above, I'm assuming you've made one of the measures that was suppose to be a measure a calculated column?😊 If you want them all as columns then change them all to a calculated column and it will work else just follow the layout I sent previously.

Many Thanks,

Taylor 😎

[Len_Barr]

Easy as. 

I'm assuming you are using a table visual. 

Go to Format your visual - Totals - toggle on