Forum Discussion
Setting constraints between multiple parameters
Hi all, I am creating a scoring band 1 to 5 based on 4 thresholds. How can I create constraints such that the thresholds should always be set in a sequence for eg, threshold for score 5 canno...
tanlooting how are you doing the banding, in a switch statement?
example
column =
SWITCH (
TRUE (),
AND ( scoringband< 1, scoringband <= 2 ), 1,
AND ( scoringband < 2, scoringband <= 3 ), 2,
0
)
I am current using 4 parameters (with slicers) to control separately and having a very simple card to indicate if the threshold is set wrongly.
I have not looked into switch statement before. Can user toggle and make adjustment with the switch statement?
tanlootingi guess im struggling to see what you doing, maybe if you can share the data with your expected result?
