Forum Discussion
Solved
Numeric parameter slicer not working properly
Hi, I have created a Numeric range parameter and using the values of that parameter in slicer. Then I have created a basic measure with switch function. Measure works correctly for 3 values i...
Use the round function for precise matching like below.
Measure = SWITCH(ROUND(Parameter[Parameter Value],2), 0.70, 100, 0.75, 200, 0.80, 300, 0.85, 400, 0.90, 500, 0.95, 600, 1000)
Use the round function for precise matching like below.
Measure = SWITCH(ROUND(Parameter[Parameter Value],2),
0.70, 100,
0.75, 200,
0.80, 300,
0.85, 400,
0.90, 500,
0.95, 600,
1000) 
Hi,
Isn't this strange? It worked correctly for 0.70, 0.75, 0.8 but not working for 0.85, 0.9, 0.95.
Any possible explanation for this logic?
Regards,
Amit