Forum Discussion
Tariff code range slicer
Hello,
maybe a little more clarity,
the combination of the four nutretional values should give only one code.
The above dataset so if product X had 0% for all 4 nutritional values the code is 7000,however if milk fat goes above 1.5% and all three other nutritional values stay below the lowest band that nutritional bucket the code is 7100.
so essentially i want 4 0-100 sliders (one for each nutritional value) where dax can read what numbers it is between and filter to give the one speicfic code.
The problem is from initial trials is using the greater then slider gives all nutitional values above that number not just the nutritonal bucket the slider value is currently in.
I believe the new what if parrameters can help but i'm struggling to get results