Forum Discussion

chinh_ho's avatar
chinh_ho
Frequent Visitor
3 years ago

Filter intersection between 2 matrix

Hi everyone, I have been stuck in a situation, and I appreciate any help. I have a fact transaction and a DimSaler table. I want to make a comparison between 2 people in my organization, so I make ...
Need Help
Greg_Deckler's avatar
Greg_Deckler
Community Champion
3 years ago

chinh_ho Maybe:

Measure =
  VAR __Table1 = DISTINCT(SELECTCOLUMNS(FILTER('Transactions',[ID] = 1),"__Type",[Type]))
  VAR __Table2 = DISTINCT(SELECTCOLUMNS(FILTER('Transactions',[ID] = 2),"__Type",[Type]))
  VAR __Common = INTERSECT(__Table1, __Table2)
RETURN
  IF(MAX('Transactions'[Type]) IN __Common, [change amount], BLANK())
  • chinh_ho's avatar
    chinh_ho
    Frequent Visitor
    3 years ago

    Hi @Greg_Deckler ,
    Thank you so much for your quick response. The Dax calculation did not work for me. I think because the relationship between Transaction and ComparisonSaler is inactive. (I need to make it inactive to filter it on the second table). In addition, I want the Dax dynamic when I select the saler on the slicer. Please help me recalculate it.