I'm trying to get the count of new customers YoY using a pivot table. The expression works fine when no selections are made. But when selections are made based on Quarter within the same year, the result varies hence duplicating the count.
E.g.: Customer 17 with Item 4666ZWJWWNB3DDZ is a new Customer in Q2, 2018. But when I select Q3 it still shows up as new customer and duplicates new customer count by Quarter.