Forum Discussion

nareshr89's avatar
nareshr89
Icon for Helper II rankHelper II
3 years ago

DAX Help

I have a column "Table[ML]" with values from 1 to 12 and the same values in Dimension table Table1[ML]   When i select a value ex 1 in Dimension table, the main table column needs to be sliced with...
Help
amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
3 years ago

nareshr89 , Option one they are joined

 

if(selectedvalues(Table1[ML]) =1, calculate(Sum(Table[Value]), filter(All(Table1), Table1[ML] in {1,2})), Sum(Table[Value]))

 

in case they are not joined

 

if(selectedvalues(Table1[ML]) =1, calculate(Sum(Table[Value]), filter((Table), Table[ML] in {1,2})), calculate(Sum(Table[Value]), filter( Table, Table[ML] in Values(Table1[ML]) ) ) )