Measure excluding defined intersection.

[_Kevin_]

Hi,

I have the following data and need a measure that excludes the intersection of Account "A2" and Branch "Br1". The sum of the measure should therefore = 100 for the two months. 

Account

A1

A2

A3

Branch

Br1

Br2

BranchAccountMonthAmount

Br1	A1	Jan	10
Br1	A2	Jan	1000
Br1	A3	Jan	10
Br2	A1	Jan	10
Br2	A2	Jan	10
Br2	A3	Jan	10
Br1	A1	Feb	10
Br1	A2	Feb	1250
Br1	A3	Feb	10
Br2	A1	Feb	10
Br2	A2	Feb	10
Br2	A3	Feb	10

Thank you in advance.

[v-yadongf-msft · Accepted solution]

Hi @_Kevin_ ,

Please try following DAX to create a measure:

SumAmount = CALCULATE(SUM('Table'[Amount]),FILTER('Table', 'Table'[Account] <> "A2" || 'Table'[Branch] <> "Br1"))

The result you want:

Best regards,

Yadong Fang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Greg_Deckler]

@_Kevin_ Maybe:

Measure =
  SUMX(FILTER('Table',[Account] = "A2" && [Branch] = "Br1"),[Amount])