Setting constraints between multiple parameters

v-yulgu-msft vanessafvg

Sorry I can't really share the files that I am working on since I am on a company laptop.

But to illustrate that, let me use a screenshot instead.

To keep it simple let's just say 3 scoring threshold. I created 3 'what if' parameters with slicers that the user could change the threshold dynamically.

for example currently score 5 threshold is at 100000. so anything above 100000, the data would be a score 5. Anything below, it will be score 4 or 3. So how can I constrain the user from setting the score5 value below score 4? since logically, it would not make sense. for eg, score 4 is set at 50000, so score5 threshold cannot go below score4

I was thinking perhaps the score 4 range could be dynamically changed to (0 to current selected value of 5):

score4= generateseries( 0 , selectedvalue of 5 )   

Note that the formula is not correct, just to illustrate the point.