Sum values with a certain group excluded

[jacobmiller2322]

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

[Mkarwa-123 · Accepted solution]

@jacobmiller2322  

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

[Mkarwa-123 · Accepted solution]

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

[Mkarwa-123 · Accepted solution]

@jacobmiller2322  

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