topic Too few arguments were passed to the FILTER function. The minimum argument count for the function is in DAX Commands and Tips

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

FahmiITM — Thu, 15 Jun 2023 05:38:24 GMT

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.

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

some_bih — Thu, 15 Jun 2023 09:56:34 GMT

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

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

FahmiITM — Fri, 16 Jun 2023 01:30:15 GMT

Thanks , it's work