Forum Discussion
Anonymous
2 years agoNot applicable
Calculated column, measures and evaluation context
Hi, Wanted help something very basis related to evaluation contexts. To illustrate, I have 3 tables as hown below: Table 1: Base Table 2: Purchase Table 3: Sales The ...
- 2 years ago
hi, Anonymous
in check_2 you gave only row context(because of calculated column ) you miss filter contextso when you wrap your code in calculate () it give filter context beacuse calculate() is filter modifier.
context transition happen only and only when both 1.row context and 2.filter context present in code.that's why in Check_2 you get 165 becuase of missing of filter context
when you wrap your code in CALCULATE() it give row context.
and it use expanded table that's why it evaluate even direct relationship is not presentin Check_1 you use measure
and in measure Calculate() present Internally that's why don't need to use Calculate().
Dangar332
2 years agoResident Rockstar
hi, Anonymous
wrap your measure in calculate()
like
calculate(SUM(Purchase[Value]))