what if to affect selected values only

[jmcph]

Hi i am creating a table visual that uses "What if" analysis as follows: 

What i want is for the Increase / Decrease on the Forecast Qty Value to affect only the selected Category and leave all other items belonging to other category as is. 

My Sales Qty Forecast measure is : 

Var SalesQty = Sum ( Sales[Qty])

Return 

 [SalesQty] * (1 * [Forecast Qty Value] )

Whereas the [Forecast Qty Value] is the default measure of the "What if" analysis. 

Forecast Qty Value = Selectedvalue ( Forecast Qty [ Forecast Qty] ,0) 

How should i formulate my measure to do this?

I hope you can help me! Thank you! 

[amitchandak · Accepted solution]

@jmcph , Make sure Category is an independent slicer

measure =
Var SalesQty = Sum ( Sales[Qty])
Return
calculate([SalesQty] * (1 * [Forecast Qty Value] ), filter(Table, Table[CATEGORY] = selectedvalue(CATEGORY[CATEGORY])))
+calculate([SalesQty], filter(Table, Table[CATEGORY] <> selectedvalue(CATEGORY[CATEGORY])))

[Anonymous]

What if you have an additional filter? 

For example, what if you only want to adjust the forecast for the selected category and for only a selected region, How would you do that?

[Anonymous]

Nevermind @amitchandak . I created a calculated table for that second filter and adjusted the formula below: calculate([SalesQty] * (1 * [Forecast Qty Value] ), filter(Table, Table[CATEGORY] = selectedvalue(CATEGORY[CATEGORY])))
+calculate([SalesQty], filter(Table, Table[CATEGORY] <> selectedvalue(CATEGORY[CATEGORY]) || Table[CATEGORY] <> selectedvalue(CATEGORY2[CATEGORY2])

[Anonymous]

Thank you so much! This was immensly helpful. 

[jmcph]

Yeah! This totally works! I just didnt understand at first on what you mean by independent slicer. 

Thank you! 

[jmcph]

Hi @amitchandak , what do you mean an independent slicer? 

I created a separate tab to test the measure you provided but it still shows the selected category only. 

Where could i have gone wrong? Or i have misinterpreted the measure you gave. 

Still thank you for answering!