Forum Discussion

hnguy71's avatar
hnguy71
Icon for Super User rankSuper User
7 years ago
Solved

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!
 
  • Anonymous's avatar
    Anonymous
    7 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

  • Anonymous's avatar
    Anonymous
    Not 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's avatar
      hnguy71
      Icon for Super User rankSuper User

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