Apr 08 2021 05:48 AM
Hi everyone. Your advice is much appreciated... hope the situtation is clear (apologies that I cannot upload files from work environment).
I have set up the following measure to count the number of distinct "Gold" tiered clients that different teams have provided consultation services to.
=calculate(DISTINCTCOUNT(ServiceDetail[Client Name]), ServiceDetail[Activity Type]=“Consultation”, ClientInfo[Tier]=“Gold”)
Apr 08 2021 05:34 PM
It's hard to say exactly. If I had your situation in front of me, I think I'd be trying some combination of the new functions (only available in the newest versions of Excel) FILTER, SORT, UNIQUE... combining them with COUNT or one of the other older functions that will count rows in a given population. FILTER can go through a database and extract (for COUNTing) rows that meet your specified criteria (and the criteria can be quite complex).
Here's a video that I have found very helpful in determining how those functions work.
https://www.youtube.com/watch?v=9I9DtFOVPIg
It may be that some other folks here will have other answers; if nothing comes forth that is satisfactory, perhaps you could post a facsimile of your sheet (actual Excel please; not just an image) just with all confidential info rendered anonymous.