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

The Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.

Reply
Tom216
Frequent Visitor

Delta measure based on slicer selections in Matrix Table

Hi, 

 

I have a problem in Power BI that I can’t seem to resolve and maybe one of you can.

 

I am attempting to find the difference between two columns in a matrix table.  The columns are based on a slicer (snapshot date).  I want this to be dynamic so that if the user selects two different snapshot dates in the slicer, the matrix table will show the difference between these newly selected dates. So to summarize:

 

Delta measure showing the difference between two selected snapshot dates.

 

Capture.JPG

Any ideas?

Thanks

1 ACCEPTED SOLUTION

@amitchandak , Thanks for your reply.

 

I tried your solution and I didn't quite work the way I intended.  I found another post which worked for me which can be found here:  https://community.powerbi.com/t5/Desktop/Difference-between-two-columns-or-rows/td-p/188185

 

Thanks again.

View solution in original post

2 REPLIES 2
amitchandak
Super User
Super User

@Tom216 , A measure like this should help

Measure =
var _max = maxx(allselected('Date'),'Date'[Date])
var _min = minx(allselected('Date'),'Date'[Date])
return
calculate(sum(table[tons]),filter(All(DATE), Date[Date] =_max)) - calculate(sum(table[tons]),filter(All(DATE), Date[Date] =_min))

Measure =
var _max = maxx(allselected('Date'),'Date'[Date])
var _min = minx(allselected('Date'),'Date'[Date])
return
calculate(sum(table[tons]),filter(Allselected(DATE), Date[Date] =_max)) - calculate(sum(table[tons]),filter(Allselected(DATE), Date[Date] =_min))

 

There is nothing column or row diff. You need to have diff measures

Full Power BI Video 20 Hours YouTube
Microsoft Fabric Series 60+ Videos YouTube
Microsoft Fabric Hindi End to End YouTube

@amitchandak , Thanks for your reply.

 

I tried your solution and I didn't quite work the way I intended.  I found another post which worked for me which can be found here:  https://community.powerbi.com/t5/Desktop/Difference-between-two-columns-or-rows/td-p/188185

 

Thanks again.

Helpful resources

Announcements
Feb2025 Sticker Challenge

Join our Community Sticker Challenge 2025

If you love stickers, then you will definitely want to check out our Community Sticker Challenge!

Jan NL Carousel

Fabric Community Update - January 2025

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