cancel
Showing results for
Did you mean:

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

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.

Any ideas?

Thanks

1 ACCEPTED SOLUTION
Frequent Visitor

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.

2 REPLIES 2
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

Frequent Visitor

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.