Reply
Topic Options
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

Calculate difference between each column value and one reference value in a column
01-26-2023
02:07 PM
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:
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
Chris
0 REPLIES 0

Helpful resources
Announcements
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.
Power BI Monthly Update - June 2025
Check out the June 2025 Power BI update to learn about new features.

Recommendations
Subject | Author | Posted | |
---|---|---|---|
05-05-2025 06:36 PM | |||
05-23-2025 10:48 AM | |||
01-27-2025 12:39 PM | |||
05-21-2025 01:51 PM | |||
06-04-2025 08:25 AM |
Top Solution Authors (Last Month)
User | Count |
---|---|
10 | |
8 | |
8 | |
8 | |
6 |
Top Kudoed Authors (Last Month)
User | Count |
---|---|
14 | |
12 | |
11 | |
9 | |
9 |