COUNT_DISCTINCT not working on selected date ranges
We have a market place and in the database we can see the customer id for each transaction. So I created a calculated field with COUNT_DISCTINCT to have a scorecard with the number of different customers that bough a product. I made the same for the sellers and listings, so that we know what share of our members purchased or bough products.
When I select "All date range" the resulting scorecards give accurate data. But when I select specific dates, the number I get is equal to the number of transactions, as if the COUNT_DISCTINCT became a COUNT.
Any idea what is the problem and how I can get this data?