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('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)))))
 
I keep on getting the following error:
Too many arguments were passed to the SUMX function. The maximum argument count for the function is 2.
 

1 Reply

  • 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