Forum Discussion
Delta measure based on slicer selections in Matrix Table
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.
Super UserTom216 , 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.