Multiple what if based on selection

[AishwariyaV]

Hey guys,

I am currently working on a scenario in power bi.

I have implemented what if analysis with a sample dataset. 

I am considering "Product Quantity" as a what if parameter, which answers the question, "What happens to my sales if i increase/decrease my quantity ".

My requirement is, when i select a particular product name i should be able to get a what if slicer for that product name.

And when i select another product name i should get another what if slicer for the second selected product. 

i.e;

I should have mutiple what if slicers for each products that has been selected. And the maximum selection allowed must be 4 or 5.

Hope someone would help me out with this!

[amitchandak]

You have used is the filter and then check the value

https://powerpivotpro.com/2013/03/hasonevalue-vs-isfiltered-vs-hasonefilter/

like

if(isfiltered(product[product]) &&max(product[product]) ="ABC",

Or use Switch( True(),

[AishwariyaV]

hi @amitchandak ,

This is how I want.

Couldn't achieve this in Power BI.

[amitchandak · Accepted solution]

Some thing like this, or combine using the switch

measure =
var _max = maxx(whatifcond,whatifcond[whatifcond])
return
calculate(sum(table[revenue]), filter(table[category] ="Condiments"))*_max