Forum Discussion

Andreas-Harlak's avatar
Andreas-Harlak
Frequent Visitor
3 years ago

Diff calculation between two mutiple selected filters

Hello, I need some help. I want to visual the difference between two multiple selected filters in a matrix. It is possible to create a measure for this.    I hope somebody can help me to so...
Need Help
amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
3 years ago

Andreas-Harlak , Try measure like

 

Date diff =
var _max = minx(allselected(Date), Date[GJ])
var _min = maxx(allselected(Date), Date[GJ])
return
calculate(sum(Table[Value]), Filter(Date,Date[GJ] =_max ) ) -calculate(sum(Table[Value]), Filter(Date,Date[GJ] =_min ) )

  • Andy1984's avatar
    Andy1984
    Frequent Visitor
    3 years ago

    amitchandak 

    Thanks for your reply. I write you from my private account now because the other is my working account.

    I think your suggestions does not work the filters are not connected with a date format it is a text type. The reason for this is we don´t have a calendar year the company year is different to it, so I created this text type and then the filters.

     

    Thank you