Skip to main content
cancel
Showing results for 
Search instead 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

Reply
nniphadk
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

 

Capture.PNG

 

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
TaylorPBI21
Resolver I
Resolver I

Hi @nniphadk,

 

I done this using 2 measures and a calculated column give this a try...😎

 

TaylorPBI21_0-1677526523704.png

 

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 😊

View solution in original post

4 REPLIES 4
TaylorPBI21
Resolver I
Resolver I

Hi @nniphadk,

 

I done this using 2 measures and a calculated column give this a try...😎

 

TaylorPBI21_0-1677526523704.png

 

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 😊

Circular dependency was detected

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 😎

Len_Barr
Resolver I
Resolver I

Easy as. 

I'm assuming you are using a table visual. 

Go to Format your visual - Totals - toggle on

Totals.jpg 

Helpful resources

Announcements
Power BI Carousel June 2024

Power BI Monthly Update - June 2024

Check out the June 2024 Power BI update to learn about new features.

PBI_Carousel_NL_June

Fabric Community Update - June 2024

Get the latest Fabric updates from Build 2024, key Skills Challenge voucher deadlines, top blogs, forum posts, and product ideas.

Top Solution Authors