Count if distinct

[Patman]

Please advise,

                                     I have three columns A & B & C

In A, there is a list of areas, in B there are lists of users, in C there are lists of groups that user can be a part of.

I need a KPI to show the count of distinct users if I choose a particular area.

Kind Regards for your help

Patman

[tresesco · Accepted solution]

Have you tried - Count(Distinct B) ?                        // Assuming B column is users

[Patman]

🙂 much appreciated 🙂