Forum Discussion
Anonymous
7 years agoNot applicable
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...
- Anonymous7 years ago
Anonymous
Value = SUMX(VALUES(Table1[Service ID]),CALCULATE(SUM(Table1[count])))
Will resolve part of your problem. :)
1 Reply
- AnonymousNot applicable
Anonymous
Value = SUMX(VALUES(Table1[Service ID]),CALCULATE(SUM(Table1[count])))
Will resolve part of your problem. :)