Forum Discussion

karolinaa's avatar
karolinaa
Frequent Visitor
3 years ago
Solved

Dynamic Column in a Table based on the Parameter Value

Hello all,   I have been trying to create a column in an already-existing table, which values should be changing based on the parameter value provided by the user in a slicer.    For that, I crea...
Need Help
Show and Tell
Tips and Tricks
  • amitchandak's avatar
    amitchandak
    3 years ago

    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) )

  • karolinaa's avatar
    karolinaa
    3 years ago

    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!

karolinaa's avatar
karolinaa
Frequent Visitor
3 years ago

My issue was solved by creating indeed all different measures. This did not update my data table, however, I created a table visual that was working properly. It turned out I was able to use those measures to create a python visual and it is working! Thank you!