IF condition error, trying to get something similar to an IFS function

[Juanpablocl96]

I'm currently trying to get a measure that sets the value as 1 per row and sums them for every row in the Opportunity table that has an existing value in the column fecha_de_admision__c, but the column Fecha_de_inscrito__c must be empty and the column StageName must not be "Descartado.

Also tried to do an if statement using the function AND as well, but didn't work either.

Currently using this formula:

Admitidos = (if(Opportunity[fecha_de_admision__c]<>blank(),if(Opportunity[Fecha_de_inscrito__c]=blank(),if(Opportunity[StageName]<>"Descartado",blank()),blank()),blank(),1))

And getting this error:
Too many arguments were passed to the IF function. The maximum argument count for the function is 3.

[Greg_Deckler]

@Juanpablocl96 First, I would highly recommend that you convert this to a SWITCH(TRUE(),...) statement. Much cleaner. You likely have a syntax error where you are not ending an IF statement properly. You might want something like:

Admitidos = 
if(
    Opportunity[fecha_de_admision__c]<>blank(),
    if(Opportunity[Fecha_de_inscrito__c]=blank(),
      if(Opportunity[StageName]<>"Descartado",
        blank(),
        blank()
      ),
      blank()
    )
    ,1
)

[Juanpablocl96]

@Greg_Deckler Thanks for trying to help! With the function you just gave me I get the exact same error as I got when trying the IF & AND functions, which is:
A single value for column 'StageName' in table 'Opportunity' cannot be determined. This can happen when a measure formula refers to a column that contains many values without specifying an aggregation such as min, max, count, or sum to get a single result.

Not sure what this error means. I'll try to formulate a function with a switch true.

Thanks for the help!

[tamerj1 · Accepted solution]

Hi @Juanpablocl96 
Please try

Admitidos =
IF (
    SELECTEDVALUE ( Opportunity[fecha_de_admision__c] ) <> BLANK ()
        && SELECTEDVALUE ( Opportunity[Fecha_de_inscrito__c] ) = BLANK ()
        && SELECTEDVALUE ( Opportunity[StageName] ) <> "Descartado",
    1
)