Forum Discussion

PabloGiraldo's avatar
PabloGiraldo
Icon for Helper IV rankHelper IV
5 years ago
Solved

What If Parameter

New to Power Bi.

 

Is it possible to tie a cell in a table to a what if parameter?

 

I want the owner to have the ability to set different variables to the What-if parameter and have the variables update on the table. In this case, "Experience" is on the second row of table. My plan is to have 8 different What-if parameters and let the owner update the numbers as he pleases. 

 

Any help is appreciated!

 

Need Help
  • v-easonf-msft's avatar
    v-easonf-msft
    5 years ago

    Hi, PabloGiraldo 

    If I understand you correctly,you may need to create another measure like that:

    Measure =
SWITCH (
    SELECTEDVALUE ( 'Table'[Column1] ),
    "A", 'Parameter A'[Parameter A Value],
    "B", 'Parameter B'[Parameter B Value],
    "C", 'Parameter C'[Parameter C Value]
)

     

     

    For more details,please check the attached pbix file.

    If I misunderstand,please share more details.

     

    Best Regards,
    Community Support Team _ Eason

6 Replies

  • amitchandak's avatar
    amitchandak
    Icon for Super User rankSuper User
    5 years ago

    PabloGiraldo , Assumed you have measure = [measure] and what if param like param1, param2 and so on

     

    You can have a measure like

    Switch ( True (),
    Max(Table[criteria]) ="Capital Cost" , selectedValue(Param1[param])* [measure],
    Max(Table[criteria]) ="Experience" , selectedValue(Param2[param])* [measure],
    /// keep on additing
    [measure]
    )

     

    Please provide your feedback comments and advice for new videos
    Tutorial Series Dax Vs SQL Direct Query PBI Tips
    Appreciate your Kudos.

    • PabloGiraldo's avatar
      PabloGiraldo
      Icon for Helper IV rankHelper IV
      5 years ago

      amitchandak thanks for the quick response.

       

      Wondering if this is anywhere near correct. I should have sent a bigger screenshot that shows my set up a little better. Do you mind looking at this again?

      Thanks.

      • v-easonf-msft's avatar
        v-easonf-msft
        Icon for Community Support rankCommunity Support
        5 years ago

        Hi, PabloGiraldo 

        If I understand you correctly,you may need to create another measure like that:

        Measure =
SWITCH (
    SELECTEDVALUE ( 'Table'[Column1] ),
    "A", 'Parameter A'[Parameter A Value],
    "B", 'Parameter B'[Parameter B Value],
    "C", 'Parameter C'[Parameter C Value]
)

         

         

        For more details,please check the attached pbix file.

        If I misunderstand,please share more details.

         

        Best Regards,
        Community Support Team _ Eason

  • PabloGiraldo's avatar
    PabloGiraldo
    Icon for Helper IV rankHelper IV
    5 years ago

    v-easonf-msft 

    Wondering if you could help me again. Is it possible to add the total for each column at the bottom? "MBR Vendor #1,2,3? The "Maximum Points" column contains the measure you helped me with so as i move sliders those values will update.

    Thanks in advance!