Reply
cmm0685
New Member
Partially syndicated - Outbound

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
avatar user

Helpful resources

Announcements
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 Power BI Update Carousel

Power BI Monthly Update - June 2025

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

June 2025 community update carousel

Fabric Community Update - June 2025

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

Top Solution Authors (Last Month)
Top Kudoed Authors (Last Month)