Forum Discussion

Pikachu-Power's avatar
Pikachu-Power
Icon for Impactful Individual rankImpactful Individual
4 years ago

VAR RETURN question

Hi all,   i have the following two measures:   MyMeasure1 = IF(SUM(Table[Amount])<1000,0,SUM(Table[Amount])-1000) and with a correction of the total:   MyMeasure2 = IF(HASONEFILTER(Table[Year...
Need Help
Pikachu-Power's avatar
Pikachu-Power
Icon for Impactful Individual rankImpactful Individual
4 years ago

Hello chenwuz,

 

yes, thats exactly what I want. But get than wrong result in writing it in one measure. As far as I understand it dont work in this way right?