Calculate & Sum with multiple criteria

[Ormie]

Hello,

I have the following DAX but it returns blank value. I am trying to filter on two values (policy year 2018/19 & 2019/20) from the same column.

CALCULATE(SUM(IntCustomSearchResults[Value of Incident]),IntCustomSearchResults[Category]="Motor",IntCustomSearchResults[Policy Year]="2018/19",IntCustomSearchResults[Policy Year]="2019/20")

Thanks,

Chris

 

[macfuller]

You have an implied AND in your logic. It's looking for values that are in both years. Is that what you want? Otherwise you'll need to make it an OR

CALCULATE (
    SUM ( IntCustomSearchResults[Value of Incident] ),
    IntCustomSearchResults[Category] = "Motor",
    OR ( IntCustomSearchResults[Policy Year] = "2018/19",
            IntCustomSearchResults[Policy Year] = "2019/20" )
)

 

[Ormie]

Yeah I was after OR, thank you very much!