Exclude Values

[erimaz]

Hello,

I need to add up some values, excluding some categories belonging to the same column.

I need to calculate the value of Commit (Column 2), excluding Won and Lost Sales Stages and including Pursuit and Negotiation Sales Stages (Column 3). How can I calculate this with a ? Thank you!

Here is the example:

Product	Target vs commit vs other	Sales Stage	Value
xxx	Target	Pursuit	12
yyy	Commit	Negotiation	14
aaa	Commit	Pursuit	2
bbb	Other	Lost	5
ccc	Commit	Won	6

[amitchandak]

@erimaz , Try like

new Measure = CALCULATE(SUM('Table'[Value]), 
FILTER(Table, Table[Target vs commit vs other] = "Commit" 
		&& NOT (Table[Sales Stage] IN {"Won", "Lost Sales"})
		&& (Table[Sales Stage] IN {"Pursuit", "Negotiation"}))
		)

[camargos88 · Accepted solution]

Hi @erimaz ,

Create this measure:

Measure = CALCULATE(SUM('Table'[Value]); FILTER('Table'; 'Table'[Target vs commit vs other] = "Commit" && NOT 'Table'[Sales Stage] IN {"Won"; "Lost Sales"}))

Example with IN :

Measure = CALCULATE(SUM('Table'[Value]); FILTER('Table'; 'Table'[Target vs commit vs other] = "Commit" && 'Table'[Sales Stage] IN {"VALUE 1"; "VALUE 2"}))

If you consider it as a solution, please mark as a solution and kudos.

Ricardo