Forum Discussion
Multiple what if based on selection
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!
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
3 Replies
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(),
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
