Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Need help with this DAX

Hello Everyone, I need to find the no of employees under a manager? Table: "emp_tbl"   No of Emps=             COUNTROWS (FILTER(ALL ('emp_tbl',                                               ...
Need Help
  • Anonymous's avatar
    Anonymous
    6 years ago

    Hi Anonymous ,

    According to my understanding, you want to count the number of Emp under each manager when their type is “New Joiners”, right?

    You could use the following formula:

    No of Emps =
COUNTROWS (
    FILTER (
        ALL ( emp_tbl ),
        emp_tbl[Manager] = MAX ( emp_tbl[Manager] )
            && emp_tbl[Emp type] = "New Joiners"
    )
)

    My visualization looks like this:

    Is the result what you want? If not, please upload some data samples and expected output.

    Please do mask sensitive data before uploading.

     

    Best Regards,

    Eyelyn Qin