Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
Solved! Go to 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 }
)
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 }
)
That is really helpful, thanks Alexis and for stackoverflow too!
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
111 | |
100 | |
80 | |
64 | |
58 |
User | Count |
---|---|
148 | |
111 | |
93 | |
84 | |
66 |