Get historical number of employees from names on records

[YevD]

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

[v-easonf-msft]

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

[amitchandak]

@YevD , For that you have need share some data.

You need to have measure like

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