Forum Discussion

Kolumam's avatar
Kolumam
Post Prodigy
8 years ago

Dynamic measure with Parameter changes

Hi All,

 

I have a column called "Annual PV Consumed MWH". I created a parameter with values from 1 to 25. So when a user clicks on 1, the calculated column should multiply the below forumla

But it's not working. When I change the slicer of X value, the energy doesn't change. Please help.

General Comment
Need Help
Show and Tell

4 Replies

  • Phil_Seamark's avatar
    Phil_Seamark
    Microsoft Employee
    8 years ago

    Hi Kolumam

     

    Are you trying to add as a calculated column or calculated measure?

     

    The syntax you use suggests a calculated column (which won't work).

     

    If you are using a calculated measure, you may need to wrap your [Annual PV Consumed MVH] with a MAX 

     

    I've attached a basic model that may be close to what you are after.

     

     

  • Zubair_Muhammad's avatar
    Zubair_Muhammad
    Community Champion
    8 years ago

    Kolumam

     

    Try wrapping the column name inside SELECTEDVALUE

    i.e.

     

    SELECTEDVALUE('Site Names (2)'[Annual PV Consumed MHW])

  • v-jiascu-msft's avatar
    v-jiascu-msft
    Microsoft Employee
    8 years ago

    Hi Kolumam,

     

    Seems you created a calculated column which is relatively stable. That means it won't change along with the slicer. Try  Phil_Seamark's solution please.

     

    Best Regards,

    Dale

  • v-jiascu-msft's avatar
    v-jiascu-msft
    Microsoft Employee
    8 years ago

    Hi Kolumam,

     

    Did you solve it? Can you share the answer or mark the proper answer as a solution, please?

     

    Best Regards,
    Dale