So the requirement is as follows -
Dim table value
When user selects A then both row 1 and 2 should be displayed . Also when the user selects A & B both 1 and 2 rows should be displayed.
Now i have written a DAX which fulfills my 1st requirement i.e. working fine in single selection, but fails in multiple selection.
Dax is as follows -
Sales = VAR Column1= SELECTEDVALUE ( DimTable[Column1]) VAR Column2 = SELECTEDVALUE ( Salestable[Column2]) RETURN IF ( find( Column1,Column2 , 1, 0 ) > 0, SUM (salestable[Sales]), BLANK() )
Kindly request you provide your help for the same.