Forum Discussion

EduardoAtalaia's avatar
EduardoAtalaia
Frequent Visitor
4 years ago
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?

Need Help
  • v-chenwuz-msft's avatar
    v-chenwuz-msft
    4 years ago

    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.

     

     

2 Replies

  • v-chenwuz-msft's avatar
    v-chenwuz-msft
    Community Support
    4 years ago

    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.