Sum values with a certain group excluded

jacobmiller2322 — Thu, 20 Jul 2023 14:23:57 GMT

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

Re: Sum values with a certain group excluded

Mkarwa-123 — Thu, 20 Jul 2023 16:44:49 GMT

Total = CALCULATE(SUM('Table'[Amt]), 'Table'[Grp] <> "Raw")

Mkarwa-123 — Thu, 27 Jul 2023 12:19:29 GMT

jacobmiller2322 Did I answer your question? Mark my post as a solution!