Dynamic measure with Parameter changes

[Kolumam]

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.

[v-jiascu-msft]

Hi @Kolumam,

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

Best Regards,
Dale

[v-jiascu-msft]

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

[Phil_Seamark]

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]

@Kolumam

Try wrapping the column name inside SELECTEDVALUE

i.e.

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