COUNT UNIQUE outlets that have the same call date

[Phil_Waite]

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

[Suvrutt_Gurjar]

Please try

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

[Phil_Waite]

Yes that worked

Thank you