cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
hnguy71 Member
Member

Dax 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!
 
sample.PNG
1 ACCEPTED SOLUTION

Accepted Solutions
Gravanita Regular Visitor
Regular Visitor

Re: Dax Summarize to Filter Values Above Threshold

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?
Capture.JPG

2 REPLIES 2
Gravanita Regular Visitor
Regular Visitor

Re: Dax Summarize to Filter Values Above Threshold

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?
Capture.JPG

Highlighted
hnguy71 Member
Member

Re: Dax Summarize to Filter Values Above Threshold

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