Too few arguments were passed to the FILTER function error

[Anonymous]

Hello,

i have following error for this measure, though i am checking . i cant find the missing ")"!

i want it to return sum of [Einsatzmenge] which have the [Status] of "Beendet"  from table "Bearbeiten - FA-Arbeitsgang":

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

M beendetquantity = CALCULATE(

SUM('Bearbeiten - FA-Arbeitsgang'[Einsatzmenge]),FILTER(ALL('Bearbeiten - FA-Arbeitsgang'[Status],'Bearbeiten - FA-Arbeitsgang'[Status]="Beendet")))

[Anonymous]

I need to change the very last part of this statement to exclude if the date is 1/1/2099. 

Current Staff =

CALCULATE( COUNTROWS( 'HRData' ),

FILTER( VALUES( 'HRData'[Hire_Date] ), 'HRData'[Hire_Date] <= max('Calendar'[Date] ) ),

FILTER( VALUES( 'HRData'[Termination_Date] ), or( 'HRData'[Termination_Date] >= MIN('Calendar'[Date] ), ISBLANK( 'HRData'[Termination_Date] ) ) ) )

This is my very first time asking a question, so if I'm not following the proper steps please let me know.

[tex628]

Hi @Anonymous, 

Just to make sure i'm on the right track. You dont want to count employees with termination date 2099/1/1? 

Br, 
J

[Anonymous]

That is correct. I'm sure its a simple matter of syntax, but again I am learning and hoping to learn more in this forum. Thanks

[tex628]

Try something along the lines of this: 

Current Staff =
CALCULATE( COUNTROWS( 'HRData' ),
FILTER( VALUES( 'HRData'[Hire_Date] ), 'HRData'[Hire_Date] <= max('Calendar'[Date] ) ),
FILTER( VALUES( 'HRData'[Termination_Date] ),
AND( 
'HRData'[Termination_Date] <> DATE(2099,1,1), 
OR( 
'HRData'[Termination_Date] >= MIN('Calendar'[Date] ), 
ISBLANK( 'HRData'[Termination_Date] ) 
) 
) ) )

[tex628 · Accepted solution]

You haven't closed the ALL statement; FILTER(ALL('Bearbeiten - FA-Arbeitsgang'[Status]),

Br,
Johannes

[forgetmenot]

I am also having smilar issue. 

can someone please advise?

Average New = CALCULATE(AVERAGE('Current & Prior Forecast Combined'[FYE FINAL]), Filter('Current & Prior Forecast Combined'[CL Type]="New"))

[Dangar332]

hi , @forgetmenot 

filter need table argument as a first expression which you not mention you only mention filter expression

Average New = CALCULATE(AVERAGE('Current & Prior Forecast Combined'[FYE FINAL]), Filter(Current & Prior Forecast Combined','Current & Prior Forecast Combined'[CL Type]="New"))

[forgetmenot]

Thank you 🙂