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!
just air code
Count Column > 1000 = IF( [Avg 2016 Booked $ per Order] >= 1000, 1, BLANK() )
should put a 1 when over 1000 that can then be counted.....
I have thought about doing this but the query I'm pulling is giant (more than 2 million rows of data). I need to do this multiple times for >1000, > 500, <200, and all for 2016 and 2017. If I have to create calculated columns for all of these measures, I'm afraid it would make the report run slow as I already have trouble with memory usage, etc.