Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.

Reply
akshay2204
Frequent Visitor

Subtract Row value from previous column total

I would like to have a dax query for subtracting row value from previous column total

 

Like for example the total for GP column is 63.7 and the next column CustGP the values should by 63.7 - 2.2 = 61.5 but it is showing up 74.44. 

 

The dax query which I am using is

01_GP_Cust = Sumx(All('Act vs Bud'),[001_GP_CY])-('Act vs Bud'[001_GP_CY])
akshay2204_0-1687613793049.png
Ultimately we need to calculate
GM Impact = (Total GP / Total Sales) - ((Total GP-Customer GP)/(Total Sales-Customer Sales))

 

Thanks in advance

 

1 REPLY 1
tamerj1
Super User
Super User

Hi @akshay2204 

try using ALLSELECTED instead of ALL

Helpful resources

Announcements
July PBI25 Carousel

Power BI Monthly Update - July 2025

Check out the July 2025 Power BI update to learn about new features.

Join our Fabric User Panel

Join our Fabric User Panel

This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.

June 2025 community update carousel

Fabric Community Update - June 2025

Find out what's new and trending in the Fabric community.