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 😊

Anonymous's avatar
Anonymous
Not applicable
3 years ago

Easy as. 

I'm assuming you are using a table visual. 

Go to Format your visual - Totals - toggle on