Forum Discussion
Solved
What IF
Hello guys! Is it possible to create scenarios (What IF) with medium ticket or markup? If I increase my average ticket, how much profit will I have, for example?
Hi EduardoAtalaia ,
You can try What If parameter in power bi.
Then create a measure to calculate Profit, please refer below.
Profit = VAR cur_ticket = SELECTEDVALUE ( Parameter[Avg_Ticket] ) VAR cur_cost = SELECTEDVALUE ( 'Table'[Cost] ) RETURN cur_ticket - cur_costResult:
Pbix in the end you can refer.
Best Regards
Community Support Team _ chenwu zhu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi EduardoAtalaia ,
You can try What If parameter in power bi.
Then create a measure to calculate Profit, please refer below.
Profit =
VAR cur_ticket =
SELECTEDVALUE ( Parameter[Avg_Ticket] )
VAR cur_cost =
SELECTEDVALUE ( 'Table'[Cost] )
RETURN
cur_ticket - cur_cost
Result:
Pbix in the end you can refer.
Best Regards
Community Support Team _ chenwu zhu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hello v-chenwuz-msft!
Thank you for your help! I managed to create the What IF!
