Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Measure =
IF([Value] <= 0.05,1,
IF([Value] > 0.05 && [Value] <= 0.15, 2,
IF([Value] > 0.15 && [Value] <= 0.25, 3,
IF([Value] > 0.25 && [Value] <= 0.5, 4,
IF([Value] > 0.5, 5, 0
)))))
Solved! Go to Solution.
@Anonymous
Like this:
Measure = SWITCH(
TRUE(),
[Value] <= 0.05, 1,
[Value] > 0.05 && [Problem Occurence %] <= 0.15, 2,
[Value] > 0.15 && [Value] <= 0.25, 3,
[Value] > 0.25 && [Value] <= 0.5, 4,
[Value] > 0.5, 5, 0 )
@Anonymous
Like this:
Measure = SWITCH(
TRUE(),
[Value] <= 0.05, 1,
[Value] > 0.05 && [Problem Occurence %] <= 0.15, 2,
[Value] > 0.15 && [Value] <= 0.25, 3,
[Value] > 0.25 && [Value] <= 0.5, 4,
[Value] > 0.5, 5, 0 )