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...
  • amitchandak's avatar
    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!