Forum Discussion

nniphadk's avatar
nniphadk
Frequent Visitor
3 years ago
Solved

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, Dif...
Need Help
Show and Tell
Tutorial Requests
  • TaylorPBI21's avatar
    TaylorPBI21
    3 years ago

    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 Anonymous solution doesn't work give this a bash...

     

    Many thanks,

     

    Taylor 😊

nniphadk's avatar
nniphadk
Frequent Visitor
3 years ago

Circular dependency was detected

TaylorPBI21's avatar
TaylorPBI21
Resolver I
3 years ago

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 😎