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

The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now! Learn more

Reply
cmm0685
New Member

Calculate difference between each column value and one reference value in a column

Hi all,

 

I would like to create a measure that creates the difference between a column and the first value of that column so I can display deltas between the first value (reference value) and the rest of the values.  For example, in Excel this would simply be:

cmm0685_0-1674770339646.png

where row 1 is bolded and serves as the reference value.  

 

I see that there is a "Variance" quick measure but that just shows the difference from row to row, not to a single reference value.  I have tried this approach but it produces all 0's when I add it as a column to my table:

 

ValueDelta = calculate(sum(Table[Value]))-calculate(FIRSTNONBLANK(Table[Value],[Value]))
 
To be clear, I would like the result to be a measure rather than a calculated column so that the result responds to slicers on the page.
 
Thanks for the help!
Chris
0 REPLIES 0

Helpful resources

Announcements
Power BI DataViz World Championships

Power BI Dataviz World Championships

The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now!

December 2025 Power BI Update Carousel

Power BI Monthly Update - December 2025

Check out the December 2025 Power BI Holiday Recap!

FabCon Atlanta 2026 carousel

FabCon Atlanta 2026

Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.