COUNT UNIQUE outlets that have the same call date

Hi,

I have a call logger and want to count the number of unique outlets in the list

So far I have

COUNT(UNIQUE(Call Logger[Outlet No]))

Below is the call logger format. How do I count unique outlet numbers in the list that share the same [Date]

Unique Id Outlet No Answer Type Name & Town Date Time User Outlet Rating
9b86437b 1 No Answer Broadstraik Inn Elrick 31/10/2019 13:49:34 phil@listersbrewery.com Active

Thanks

Phil

Please try

COUNT(UNIQUE(SELECT(Call Logger[Outlet No], [Date]=[_THISROW].[Date])))

2 Likes

Yes that worked

Thank you

2 Likes