What IF

[EduardoAtalaia]

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?

[v-chenwuz-msft · Accepted solution]

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.

[EduardoAtalaia]

Hello @v-chenwuz-msft!
Thank you for your help! I managed to create the What IF!