Dax Summarize to Filter Values Above Threshold

[hnguy71]

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!

[Anonymous · Accepted solution]

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]

Yes! That works perfectly Gravanita! I appreciate the quick response!