dax filtering

[adavid999]

Hello, please can someone explain why these two measures produce different results (something to do with the AND/OR but I don't understand why these would differ)? (I am reposting this as I made an error in my original post)

measure 1 check (no.) =
CALCULATE (
    COUNT ( fct_core[colour] ),
    fct_core[type] = 1
        || fct_core[type] = 2
        || fct_core[type] = 3
        && fct_core[colour] = 5
        || fct_core[colour] = 6
        || fct_core[colour] = 7
        || fct_core[colour] = 8
)

and:

measure 2 check (no.) =
CALCULATE (
    COUNT ( fct_core[colour] ),
    fct_core[type] >= 1
        && fct_core[type] <= 3
        && fct_core[colour] = 5
        || fct_core[colour] = 6
        || fct_core[colour] = 7
        || fct_core[colour] = 8
)

thanks,

A

[AlexisOlson · Accepted solution]

Suppose you have type 2 and color 4. Then measure 1 would count it but not measure 2.

Note that your logical combination

T1 || T2 || T3 && C5 || C6 || C7 || C8

is equivalent to

T1 || T2 || (T3 && C5) || C6 || C7 || C8

not as I think you intended

(T1 || T2 || T3) && (C5 || C6 || C7 || C8)

I'd rewrite the measure as

check (no.) =
CALCULATE (
    COUNT ( fct_core[colour] ),
    fct_core[type] IN { 1, 2, 3 },
    fct_core[colour] IN { 5, 6, 7, 8 }
)

[adavid999]

That is really helpful, thanks Alexis and for stackoverflow too!