Forum Discussion

FahmiITM's avatar
FahmiITM
Regular Visitor
3 years ago
Solved

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

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.
  • some_bih's avatar
    some_bih
    3 years ago

    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

2 Replies

  • some_bih's avatar
    some_bih
    Icon for Community Champion rankCommunity Champion
    3 years ago

    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