Forum Discussion
Solved
Distinct Count with Filter
I want to count the number of clients who have an average order amount greater than $1000. In my table, I can clearly see there should be 16, but my counting measure is returning 7 and I have no idea...
The problem seems to have been fixed by moving my measures to a different table in my report. Thanks everyone!
I am not able to reproduce your issue using my sample data. Could you please share sample data of 'Order Detail-Bookings' table 'Order Header-Bookings' that can be copied and pasted so that I can test? We also need to know which field you use to create relationship between the two tables.
Regards,
Lydia
The problem seems to have been fixed by moving my measures to a different table in my report. Thanks everyone!