Forum Discussion

Chants89's avatar
Chants89
Regular Visitor
4 years ago

IF Statement with multiple conditions

Please can someone help me with this IF statement and let me know what I am doing wrong:   IF(AND(SUM('Values'[Values])<=SUMX(FILTER(JoinedExtractData,JoinedExtractData[measure var _last6]*4),SUM(...
amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
4 years ago

Chants89 , The first filter end here

FILTER(JoinedExtractData,JoinedExtractData[measure var _last6]*4)

 

Then there is comparison , the sumx never end

SUM('Values'[Values])>=SUMX(FILTER(JoinedExtractData,JoinedExtractData[measure var _last6]*0.75),2,
IF((SUM('Values'[Values])<SUMX(FILTER(JoinedExtractData,JoinedExtractData[measure var _last6]*4),1,
IF(SUM('Values'[Values])>SUMX(FILTER(JoinedExtractData,JoinedExtractData[measure var _last6]*0.75),3,0)))))

 

please write them in var and the try to club later

 

Us Switch with true option if needed