Forum Discussion
Dynamic Column in a Table based on the Parameter Value
karolinaa , You have to create a measure , the column can not use the selected value
Total hours = Sumx('Table', 'Table'[Age] * SELECTEDVALUE('Parameter Hours p.a.'[Parameter Hours p.a.], 25) )
Hello v-jingzhang,
Thanks for your answer! In my Python visual, I am trying to build a 3D graph and Total hours are one of its dimensions (Total hours, Age, Price).
For now I entered the values manually and it works, however, I would need to calculate the Total hours for every 20 records in my table based on the user's input. Ideally, that would update the table on which my visual is based. I don't think it is possible to be done with a measure. Is there any workarounds that you're aware of?
Thanks and best regards!
Hi karolinaa
Calculated columns cannot be updated by slicer values. This is by design. In this scenario, your calculated column cannot get the selected value of the parameter so it always chooses the alternative value 25.
Where do you use this calculated column in your Python visual? Is it possible to use a measure at the same place?
Best Regards,
Community Support Team _ Jing
If this post helps, please Accept it as Solution to help other members find it. Highly appreciate your Kudos!
Hello v-jingzhang,
Thanks for your answer! In my Python visual, I am trying to build a 3D graph and Total hours are one of its dimensions (Total hours, Age, Price).
For now I entered the values manually and it works, however, I would need to calculate the Total hours for every 20 records in my table based on the user's input. Ideally, that would update the table on which my visual is based. I don't think it is possible to be done with a measure. Is there any workarounds that you're aware of?
Thanks and best regards!