Combine Rows on Unique ID And Other Criteria

[Anonymous]

Suppose I have a (much larger) table that resembles this: 

I am looking to combine the rows with the unique service ID = 1 so the table looks like this:

Finally, I am wondering if it is possible for me to, once more, combine certain rows by summing the count column if the count is particularly small (in this case, say a single-digit number). The outcome I am looking for would resemble this:

Any help is appreciated! I apologize if this is actually an extremely simple task...

[Anonymous · Accepted solution]

@Anonymous 

Value = SUMX(VALUES(Table1[Service ID]),CALCULATE(SUM(Table1[count])))

Will resolve part of your problem. 🙂