topic Re: Dax in DAX Commands and Tips

Dax

Farhana110 — Wed, 08 Nov 2023 18:46:33 GMT

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.

Re: Dax

Dangar332 — Thu, 09 Nov 2023 16:02:28 GMT

hi, Farhana110

Farhana110

create measure

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

make table visual drag manager column and measure(result)

Re: Dax

FreemanZ — Thu, 09 Nov 2023 02:15:52 GMT

hi Farhana110 ,

Could you post some sample data for the mentioned columns?

Re: Dax

Farhana110 — Thu, 09 Nov 2023 14:56:59 GMT

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

Re: Dax

FreemanZ — Thu, 09 Nov 2023 15:02:59 GMT

hi Farhana110 ,

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

measure = countrows(tablename)