Forum Discussion
Counting Unique Values with Multiple Criteria
I am using the following formula to count the amount of unique freight carriers I use each day at work: =SUM(--LEN(UNIQUE(FILTER(Orders[Carrier],Orders[Shipped]=Dates[@[11/22]],"")))>0)) Orders[Car...
AND returns only a single TRUE/FALSE value, not an array. Try
=SUM(--LEN(UNIQUE(FILTER(Orders[Carrier],(Orders[Shipped]>=AT3)*(Orders[Shipped]<=AT32),"")))>0))