Forum Discussion
Kolumam
8 years agoPost Prodigy
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 ...
Phil_Seamark
8 years agoMicrosoft Employee
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.