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

[FahmiITM]

Hi Everyone,

I am newbie use power BI please help. 

i want create dashboard , and this dashboard consist 2 tables. 
in tables first i create new column , content of this column get from second column .

i use this 

OracleUser = CALCULATE(FIRSTNONBLANK(DW_ORACLE_LOGIN_EMPLOYEE[LOGIN_NAME],1),FILTER(ALL(DW_ORACLE_LOGIN_EMPLOYEE[LOGIN_NAME],DW_ORACLE_LOGIN_EMPLOYEE[LOGIN_EMAIL]=ORA_view_ad_employeeprofile[EMAIL_OFFICE])))


i create OracleUser , with content DW_ORACLE_LOGIN_EMPLOYEE[LOGIN_NAME, the condition DW_ORACLE_LOGIN_EMPLOYEE[LOGIN_EMAIL]=ORA_view_ad_employeeprofile[EMAIL_OFFICE

but there is an error Too few arguments were passed to the FILTER function. The minimum argument count for the function is 2.

[FahmiITM]

Thanks , it's work

[some_bih · Accepted solution]

Hi @FahmiITM  Function filter ask first argument table and second expression / column with condition.

check your part FILTER(ALL (<this could be table>), I guess DW_ORACLE_LOGIN_EMPLOYEE, and check how many ) you should have. I hope this help