Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

How Get In measures

Cost = CALCULATE(SUM(A[Cost]),FILTER(A,A[Group]=B[Group]))   This my calculated column DAX its giving expected result, I have tried many ways to create this in Measure But I am not able to achive t...
  • johnt75's avatar
    johnt75
    4 years ago

    I think this will work

    Cost = CALCULATE( SUM('A'[Cost]), TREATAS( VALUES('B'[Group]), 'A'[Group]) )
johnt75's avatar
johnt75
Super User
4 years ago

I think this will work

Cost = CALCULATE( SUM('A'[Cost]), TREATAS( VALUES('B'[Group]), 'A'[Group]) )