topic Re: Measure excluding defined intersection. in DAX Commands and Tips

Measure excluding defined intersection.

_Kevin_ — Mon, 26 Sep 2022 16:40:52 GMT

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

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.

Re: Measure excluding defined intersection.

Greg_Deckler — Mon, 26 Sep 2022 16:47:47 GMT

_Kevin_ Maybe:

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

Re: Measure excluding defined intersection.

v-yadongf-msft — Tue, 27 Sep 2022 02:49:31 GMT

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.