Forum Discussion

Farhana110's avatar
Farhana110
Frequent Visitor
2 years ago

Dax

Hi,

Hope you are doing well and keeping safe!

 

I need the the advice on below scenario.

In my dataset, I have column " Manager Name"  and employee I'd of their team under each manager. I want to calculate total number of employees under that manager. How to do this using dax.

 

Thanks in advance. Your help would be greatly appreciated.

 

 

 

DAX
measure

4 Replies

  • Dangar332's avatar
    Dangar332
    Icon for Resident Rockstar rankResident Rockstar
    2 years ago

    hi, Farhana110 

    Farhana110 

     

    create measure

     

    result =
 distinctcount('tablename'[employeeid column])

     

     

     

     

    make table visual drag manager column and measure(result)

    • Farhana110's avatar
      Farhana110
      Frequent Visitor
      2 years ago

       

       FreemanZ, Thanks for the replay. You can use above sample dataset.

      I am looking for below result using calculated DAX,

      ABC-4

      XYZ-2

      PQR - 3

      • FreemanZ's avatar
        FreemanZ
        Icon for Super User rankSuper User
        2 years ago

        hi Farhana110 ,

         

        just plot a table visual with manager column and a measure like:

        measure = countrows(tablename)