Forum Discussion

_Kevin_'s avatar
_Kevin_
Helper I
3 years ago
Solved

Measure excluding defined intersection.

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

Br1A1Jan10
Br1A2Jan1000
Br1A3Jan10
Br2A1Jan10
Br2A2Jan10
Br2A3Jan10
Br1A1Feb10
Br1A2Feb1250
Br1A3Feb10
Br2A1Feb10
Br2A2Feb10
Br2A3Feb10



Thank you in advance.

Exclude from measure
exclude intersection
Measure excluding
  • v-yadongf-msft's avatar
    v-yadongf-msft
    3 years ago

    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.

2 Replies

  • v-yadongf-msft's avatar
    v-yadongf-msft
    Community Support
    3 years ago

    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.