cancel
Showing results for
Did you mean:

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Frequent Visitor

## PowerBI Desktop Sum Values, Grand Total

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

1 ACCEPTED SOLUTION
Resolver I

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 😊

4 REPLIES 4
Resolver I

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 😊

Frequent Visitor

Circular dependency was detected

Resolver I

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 😎

Resolver I

Easy as.

I'm assuming you are using a table visual.

Go to Format your visual - Totals - toggle on

Announcements