measure error

[Anonymous]

My measure as below. 

Measure 2 = VAR __CurrentMeasure =

CALCULATE (

COUNT ( 'Before'[Start (Date)]),

FILTER ('Before 2021',

AND ( YEAR(DATEVALUE('Before'[Start(Date)])) <> 2021 , MONTH(DATEVALUE('Before'[Start(Date)])) <> 1 , 'Before'[Start (Date)] <> BLANK())

)

)

RETURN

IF ( ISBLANK ( __CurrentMeasure ), 0, __CurrentMeasure )

It error Too many arguments were passed to the AND function. The maximum argument count for the function is 2.

[PhilipTreacy · Accepted solution]

Hi @Anonymous 

AND() only takes two arguments. If you want to use more then you need to use &&

Measure 2 = VAR __CurrentMeasure =
CALCULATE (
COUNT ( 'Before'[Start (Date)]),
FILTER ('Before 2021',
 ( YEAR(DATEVALUE('Before'[Start(Date)])) <> 2021 && MONTH(DATEVALUE('Before'[Start(Date)])) <> 1  && 'Before'[Start (Date)] <> BLANK())
)
)
RETURN
IF ( ISBLANK ( __CurrentMeasure ), 0, __CurrentMeasure )

Regards

Phil

[mahoneypat]

You can either nest multiple ANDs together or (easier) just use && between each term instead of AND.  Also, you should avoid filtering the whole table.  It is better practice to use this approach

FILTER(ALL('Before'[Start(date)]), ... && ... &&... )

Pat