Forum Discussion

adavid999's avatar
adavid999
Icon for Helper V rankHelper V
5 years ago
Solved

dax filtering

Hello, 

 

please can someone help me understand why these two filters produce slightly different results (I would have thought they are doing the same job but I am obviously misunderstanding something)?

 

filter 1 =
CALCULATE (
    COUNT ( table2[id] ),
    table2[gender] >= 1
        && table2[gender] <= 3
        && table2[zone] >= 5
        && table2[zone] <= 8
)

 

filter 2 =
CALCULATE (
    COUNT ( table2[id] ),
    table2[gender] >= 1
        && table2[gender] <= 3
        && table2[zone] == 5
        || table2[zone] == 6
        || table2[zone] == 7
        || table2[zone] == 8
)

Thanks,

A