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, 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

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 😊

4 Replies

  • 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

     

  • 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 😊

      • 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 😎