Forum Discussion

Tom216's avatar
Tom216
Frequent Visitor
6 years ago
Solved

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

Need Help

2 Replies

  • amitchandak's avatar
    amitchandak
    Icon for Super User rankSuper User
    6 years ago

    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