topic Re: Get historical number of employees from names on records in DAX Commands and Tips

Get historical number of employees from names on records

YevD — Wed, 09 Nov 2022 01:07:17 GMT

Hello,

Is there a way I can get the historical count of analysts who have performed 1 or more action in the attached matrix? For example, Jan would have 16 analysts, July 20, and October 19.

Best

YevD

Re: Get historical number of employees from names on records

amitchandak — Wed, 09 Nov 2022 02:31:40 GMT

YevD , For that you have need share some data.

You need to have measure like

countx(filter(Table, Not(Isblank(Table[Action])) ), Table[Agent])

Re: Get historical number of employees from names on records

v-easonf-msft — Mon, 14 Nov 2022 08:01:09 GMT

Hi, YevD

Please try using function DISTINCTCOUNT in DAX.

distinctcount = DISTINCTCOUNT('Table'[Analyst])

then apply it to a table visual.

If it doesn't work, please sahre a sample file for further search.

Best Regards,
Community Support Team _ Eason