Dax

[Farhana110]

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.

[FreemanZ]

hi @Farhana110 ,

Could you post some sample data for the mentioned columns?

[Farhana110]

 

 @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]

hi @Farhana110 ,

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

measure = countrows(tablename)

[Dangar332]

hi, @Farhana110 

@Farhana110 

create measure

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

make table visual drag manager column and measure(result)