Forum Discussion

lukedaly01's avatar
lukedaly01
Regular Visitor
5 years ago

What If Slicer?

I have a set of data where I want the quantities to decrement using a "What If" scenario

 

I want to see how the quantities of part numbers would adjust down if a product was built, thereby consuming certain part numbers by specific quantities, ie 106-562-497 would decrease by 2, 106-887-101 would decrease by 1 & 106-887-198 would decrease by 1.

 

Can a Slicer be created to adjust values dependant on a certain number of set part numbers being consumed?

 

Any help  / suggestions would be appreciated.

Need Help

1 Reply

  • MFelix's avatar
    MFelix
    Icon for Super User rankSuper User
    5 years ago

    Hi lukedaly01 ,

     

    This is possible if you set some specific values to those calculations, for example if you have the values of the SKU 

    106-562-497 has you refer this would need to do something similar to this

     

    would decrease by 2, 106-887-101 would decrease by 1 & 106-887-198 would decrease by 1.

     

    Increase Decrease = SWITCH(SELECTEDVALUE(Table[Sku]),
"106-562-497", [What if paramater] * -2,
"106-887-101", [What if paramater] * -1,
"106-887-198", [What if paramater] * -1)

    This would be just an example, best option is instead of having this values in a measure is to have a table with the relationship between the skus and the increase decrease of each unit selected in the what if parameter and then make a multiplication of the value of the what if by that specific column.