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 😊

TaylorPBI21's avatar
TaylorPBI21
Resolver I
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 😎