Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Report creation with dynamic values

Hi,

I have a requirement with 2 data collections(A to E and L to P), shown below.

It has to 2 parameters in column 'I' and 'T' as Paywall Users and Conversion, the user wants to enter values into these fields and this will result into Start Estimate parameter = I3*I5(paywall*conversion).

The "Start Estimate" in I7 is used to calculate columns F and G.

Columns G and R are then plotted on the same graph.

Can we produce this into power BI.

 

Please help.

 

Thanks in Advance

Need Help
  • v-yingjl's avatar
    v-yingjl
    5 years ago

    Hi Anonymous ,

    You can create multiple what-if parameters and apply it in calculation.

    Create these measures to compare in line chart:

    Revenue1 = MIN('Paywall Users'[Paywall Users]) * MAX('Conversion'[Conversion]) * MIN('RATE'[RATE])  * SELECTEDVALUE(Table1[Retention]) * SELECTEDVALUE(Table1[LTV])
    Revenue2 = MAX('Paywall Users'[Paywall Users]) * MIN('Conversion'[Conversion]) * MAX('RATE'[RATE])  * SELECTEDVALUE(Table2[Retention]) * SELECTEDVALUE(Table2[LTV])

    Start Estimate value:

    Start Estimate = SELECTEDVALUE('Paywall Users'[Paywall Users]) * SELECTEDVALUE(Conversion[Conversion])

    Attached a sample file in the below, hopes to help you.

     

    Best Regards,
    Community Support Team _ Yingjie Li
    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

4 Replies

  • lbendlin's avatar
    lbendlin
    Super User
    5 years ago

    Yes, learn how "What If Parameters"  work in Power BI. They allow some limited modeling.

    • Anonymous's avatar
      Anonymous
      Not applicable
      5 years ago

      Thank you for the reply, but can this be possible in Power BI having both Revenues on the same X-axis 

  • v-yingjl's avatar
    v-yingjl
    Community Support
    5 years ago

    Hi Anonymous ,

    You can create multiple what-if parameters and apply it in calculation.

    Create these measures to compare in line chart:

    Revenue1 = MIN('Paywall Users'[Paywall Users]) * MAX('Conversion'[Conversion]) * MIN('RATE'[RATE])  * SELECTEDVALUE(Table1[Retention]) * SELECTEDVALUE(Table1[LTV])
    Revenue2 = MAX('Paywall Users'[Paywall Users]) * MIN('Conversion'[Conversion]) * MAX('RATE'[RATE])  * SELECTEDVALUE(Table2[Retention]) * SELECTEDVALUE(Table2[LTV])

    Start Estimate value:

    Start Estimate = SELECTEDVALUE('Paywall Users'[Paywall Users]) * SELECTEDVALUE(Conversion[Conversion])

    Attached a sample file in the below, hopes to help you.

     

    Best Regards,
    Community Support Team _ Yingjie Li
    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.