Forum Discussion
hnguy71
Super User
7 years agoDax Summarize to Filter Values Above Threshold
Hello everyone!
I have a dataset which consists of 3 columns: Name, Number, Category. I want to summarize to see if any value in the Name category has any amount greater than 1000.
So if we have 3 customers and 1 customer has at least 1 row with a value greater than 1000, omit in the summarize. As you can see with the attached picture, "test" has values greater than 1000 and I'd like to summarize a table to not include "test". Any help or leads would be appreciated!
- Anonymous7 years ago
You want to omit just the entry over 1000 or all the entries of a customer that has an entry over 1000?
Is this what you want?
2 Replies
- AnonymousNot applicable
You want to omit just the entry over 1000 or all the entries of a customer that has an entry over 1000?
Is this what you want?
- hnguy71
Super User
Yes! That works perfectly Gravanita! I appreciate the quick response!