count/group by for column with added filter

[thampton]

i have a table with clientid / salesorder# / orderdate. I would like to have a measure to count how many clients have more than 2 or more orders total. So im thinking this would need to summarize, then do a filter, but not sure how that syntax would work. 

For example, below is an example table. I would like a measure to show 1 because only 1 client has had 2 or more orders in this time frame. 

Client           Order ID               Date

a                   1563                    9-2-2020

a                   1234                   9-2-2020

a                   2345                   9-6-2020

b                  5678                    9-7-2020

Thank you

[amitchandak · Accepted solution]

@thampton ,Try

Client >2 order =countx(filter(summarize(Table,Table[Client] , "_1", count(Table[Order ID])),[_1]>=2),[Client])

[thampton]

@amitchandak This is awesome! Thank you so much.