Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago

VAR RETURN syntax not working

Hi guys, can anyone explain why the first DAX formula gives a correct result: AVERAGE = CALCULATE(AVERAGE('Tab 3'[Measure]); CALCULATETABLE( TREATAS(VALUES('Tab 2'[K_TWO]);'Tab 3'[K_TWO]) ;...