What If Slicer?

[lukedaly01]

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.

[MFelix]

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.