dax filtering

Question

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)&nbsp;measure 1 check (no.)&nbsp;=CALCULATE&nbsp;(&nbsp;&nbsp;&nbsp;&nbsp;COUNT&nbsp;(&nbsp;fct_core[colour]&nbsp;),&nbsp;&nbsp;&nbsp;&nbsp;fct_core[type]&nbsp;=&nbsp;1&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;||&nbsp;fct_core[type]&nbsp;=&nbsp;2&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;||&nbsp;fct_core[type]&nbsp;=&nbsp;3&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&amp;&amp;&nbsp;fct_core[colour]&nbsp;=&nbsp;5&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;||&nbsp;fct_core[colour]&nbsp;=&nbsp;6&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;||&nbsp;fct_core[colour]&nbsp;=&nbsp;7&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;||&nbsp;fct_core[colour]&nbsp;=&nbsp;8)&nbsp;and:&nbsp;measure 2 check (no.)&nbsp;=CALCULATE&nbsp;(&nbsp;&nbsp;&nbsp;&nbsp;COUNT&nbsp;(&nbsp;fct_core[colour]&nbsp;),&nbsp;&nbsp;&nbsp;&nbsp;fct_core[type]&nbsp;&gt;=&nbsp;1&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&amp;&amp;&nbsp;fct_core[type]&nbsp;&lt;=&nbsp;3&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&amp;&amp;&nbsp;fct_core[colour]&nbsp;=&nbsp;5&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;||&nbsp;fct_core[colour]&nbsp;=&nbsp;6&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;||&nbsp;fct_core[colour]&nbsp;=&nbsp;7&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;||&nbsp;fct_core[colour]&nbsp;=&nbsp;8)&nbsp;thanks,A

alexisolson · Accepted Answer

Suppose you have type 2 and color 4. Then measure 1 would count it but not measure 2.&nbsp;Note that your logical combinationT1 || T2 || T3 &amp;&amp; C5 || C6 || C7 || C8is equivalent toT1 || T2 || (T3 &amp;&amp; C5) || C6 || C7 || C8not as I think you intended(T1 || T2 || T3) &amp;&amp; (C5 || C6 || C7 || C8)&nbsp;I'd rewrite the measure as&nbsp;check (no.) =
CALCULATE (
    COUNT ( fct_core[colour] ),
    fct_core[type] IN { 1, 2, 3 },
    fct_core[colour] IN { 5, 6, 7, 8 }
)&nbsp;

Forum Discussion

dax filtering

2 Replies

Related content

DAX FILTER with multiple criteria

DAX MEASURE TO FILTER

Dax

DAX Formula Help

Dinamic dax with filters