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 ...
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.

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.