Forum Discussion
jacobmiller2322
3 years agoFrequent Visitor
Sum values with a certain group excluded
Hi,
I am trying to do a project and am running into an issue.
I am attempting to take the sum of a column, but want to only take the sum of the rows that are under a certain grouping of 22 I have made.
Normally I would be fine, but I have 22 groupings and want to take the sum of $ for 21/22 of them.
Here is an example:
Group $ Amt
Parts $75
Parts $65
Raw $55
FG $75
Rent $85
Rent $15
In this example I would like to find out how to sum the $ with everything besides the raw group.
So basically how would I write a measure that would return $315 in this example
- Total = CALCULATE(SUM('Table'[Amt]), 'Table'[Grp] <> "Raw")
jacobmiller2322 Did I answer your question? Mark my post as a solution!
2 Replies
- Mkarwa-123
Resolver II
Total = CALCULATE(SUM('Table'[Amt]), 'Table'[Grp] <> "Raw") - Mkarwa-123
Resolver II
jacobmiller2322 Did I answer your question? Mark my post as a solution!