Forum Discussion
Solved
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 th...
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
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