Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

Combine Rows on Unique ID And Other Criteria

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's avatar
    Anonymous
    7 years ago

    Anonymous 

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

    Will resolve part of your problem. :)

1 Reply

  • Anonymous's avatar
    Anonymous
    Not applicable

    Anonymous 

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

    Will resolve part of your problem. :)