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 solve this situation. Thanks a lot

Need Help

2 Replies

  • amitchandak's avatar
    amitchandak
    Super 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