Too few arguments were passed to the IF function. The minimum argument count for the function is 2

[timward10]

Hi, 

Can someone help me with the below formula

Assay Count Jan'25 = if(CALCULATE(COUNT('EXENT Funnel - by Product'[Assay Jan 24]))+0+CALCULATE(COUNT('EXENT Funnel - by Product'[Assay Feb 24]))+CALCULATE(COUNT('EXENT Funnel - by Product'[Assay Mar 24]))+CALCULATE(COUNT('EXENT Funnel - by Product'[Assay Apr 24]))+CALCULATE(COUNT('EXENT Funnel - by Product'[Assay May 24]))+CALCULATE(COUNT('EXENT Funnel - by Product'[Assay Jun 24]))+CALCULATE(COUNT('EXENT Funnel - by Product'[Assay Jul 24]))++CALCULATE(COUNT('EXENT Funnel - by Product'[Assay Aug 24]))++CALCULATE(COUNT('EXENT Funnel - by Product'[Assay Sep 24]))++CALCULATE(COUNT('EXENT Funnel - by Product'[Assay Oct 24]))+CALCULATE(COUNT('EXENT Funnel - by Product'[Assay Nov 24]))++CALCULATE(COUNT('EXENT Funnel - by Product'[Assay Dec 24])=12,BLANK(),if('EXENT Funnel - by Product'[Assay Dec 24]<>BLANK(),'EXENT Funnel - by Product'[Assay Dec 24],if('EXENT Funnel - by Product'[Assay Rev Start Date]="Jan 25",[Assay Revenue Split],BLANK()))))

It is returning Too few arguments were passed to the IF function. The minimum argument count for the function is 2

Thanks 

[bhanu_gautam · Accepted solution]

@timward10 , Use this

DAX
Assay Count Jan'25 =
IF(
CALCULATE(COUNT('EXENT Funnel - by Product'[Assay Jan 24])) +
CALCULATE(COUNT('EXENT Funnel - by Product'[Assay Feb 24])) +
CALCULATE(COUNT('EXENT Funnel - by Product'[Assay Mar 24])) +
CALCULATE(COUNT('EXENT Funnel - by Product'[Assay Apr 24])) +
CALCULATE(COUNT('EXENT Funnel - by Product'[Assay May 24])) +
CALCULATE(COUNT('EXENT Funnel - by Product'[Assay Jun 24])) +
CALCULATE(COUNT('EXENT Funnel - by Product'[Assay Jul 24])) +
CALCULATE(COUNT('EXENT Funnel - by Product'[Assay Aug 24])) +
CALCULATE(COUNT('EXENT Funnel - by Product'[Assay Sep 24])) +
CALCULATE(COUNT('EXENT Funnel - by Product'[Assay Oct 24])) +
CALCULATE(COUNT('EXENT Funnel - by Product'[Assay Nov 24])) +
CALCULATE(COUNT('EXENT Funnel - by Product'[Assay Dec 24])) = 12,
BLANK(),
IF(
'EXENT Funnel - by Product'[Assay Dec 24] <> BLANK(),
'EXENT Funnel - by Product'[Assay Dec 24],
IF(
'EXENT Funnel - by Product'[Assay Rev Start Date] = "Jan 25",
[Assay Revenue Split],
BLANK()
)
)
)

[timward10]

Hi @bhanu_gautam,

When I move the DAX over to the next column to repeat the formula for Feb, it tells me the below;

A circular dependency was detected: EXENT Funnel - by Product[Assay Feb'25], EXENT Funnel - by Product[Assay Jan 25], EXENT Funnel - by Product[Assay Feb'25].

DAX is just updated in accordance with looking at the new columns. 

Assay Feb 25 =

IF(

CALCULATE(COUNT('EXENT Funnel - by Product'[Assay Jan 25])) +

CALCULATE(COUNT('EXENT Funnel - by Product'[Assay Feb 24])) +

CALCULATE(COUNT('EXENT Funnel - by Product'[Assay Mar 24])) +

CALCULATE(COUNT('EXENT Funnel - by Product'[Assay Apr 24])) +

CALCULATE(COUNT('EXENT Funnel - by Product'[Assay May 24])) +

CALCULATE(COUNT('EXENT Funnel - by Product'[Assay Jun 24])) +

CALCULATE(COUNT('EXENT Funnel - by Product'[Assay Jul 24])) +

CALCULATE(COUNT('EXENT Funnel - by Product'[Assay Aug 24])) +

CALCULATE(COUNT('EXENT Funnel - by Product'[Assay Sep 24])) +

CALCULATE(COUNT('EXENT Funnel - by Product'[Assay Oct 24])) +

CALCULATE(COUNT('EXENT Funnel - by Product'[Assay Nov 24])) +

CALCULATE(COUNT('EXENT Funnel - by Product'[Assay Dec 24])) = 12,

BLANK(),

IF(

'EXENT Funnel - by Product'[Assay Jan 25] <> BLANK(),

'EXENT Funnel - by Product'[Assay Jan 25],

IF(

'EXENT Funnel - by Product'[Assay Rev Start Date] = "Feb 25",

[Assay Revenue Split],

BLANK()

)

)

)

[timward10]

Fantastic! Thank you @bhanu_gautam