Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

Dynamic calculation for difference between two non-date matrix columns

I have a matrix with region related fields as the column headers.  A slicer for this matrix contains about 40 regional related fields available to populate the matrix columns.  I have instructions on...
Need Help
  • Ashish_Mathur's avatar
    Ashish_Mathur
    4 years ago

    Hi,

    Here's a start.  Download my PBI file from here.

    Hope this helps.

lbendlin's avatar
lbendlin
Super User
4 years ago

When you say "difference"  do you mean "difference based on the alphabetical order of the two regions picked by the user regardles which region they picked first" ?

 

DAX can tell you which filters are applied but it has no idea in which sequence they were applied.

  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

    Hello lbendlin and thanks for your reply.  I need any difference between the two columns, the alphabetical order and the choice sequence order are irrelevant.  I will only need the difference between two columns, there will never be 3 or more coulmns.

    Thanks!

    • lbendlin's avatar
      lbendlin
      Super User
      4 years ago

      In that case the difference between MIN(ALLSELECTED) and MAX(ALLSELECTED) should suffice.