Forum Discussion

AishwariyaV's avatar
AishwariyaV
Icon for Helper IV rankHelper IV
6 years ago
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...
Need Help
Show and Tell
Tips and Tricks
  • amitchandak's avatar
    amitchandak
    6 years ago

    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
AishwariyaV's avatar
AishwariyaV
Icon for Helper IV rankHelper IV
6 years ago

hi amitchandak ,

This is how I want.

 

Couldn't achieve this in Power BI.

amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
6 years ago

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