topic Re: IF condition error, trying to get something similar to an IFS function in DAX Commands and Tips

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

Juanpablocl96 — Thu, 04 Aug 2022 14:58:26 GMT

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.

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

Greg_Deckler — Thu, 04 Aug 2022 15:10:57 GMT

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 )

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

Juanpablocl96 — Thu, 04 Aug 2022 15:25:47 GMT

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!

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

tamerj1 — Thu, 04 Aug 2022 16:56:12 GMT

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 )