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

Grow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.

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

@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
RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

MayPowerBICarousel

Power BI Monthly Update - May 2024

Check out the May 2024 Power BI update to learn about new features.