Dynamic Column in a Table based on the Parameter Value

[karolinaa]

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 created a new parameter (numeric range) and added a calculated column to my table.

Parameter Hours p.a. = GENERATESERIES(0, 10000, 1000)

Parameter Hours p.a. Value = SELECTEDVALUE('Parameter Hours p.a.'[Parameter Hours p.a.], 25)

Total hours = 'Table'[Age] * 'Parameter Hours p.a.'[Parameter Hours p.a. Value]

However, the only thing I see in my table is alternate result (25), as if no value was selected. 

I would need this table to be updated automatically after clicking enter, so that my Python visual gets updated once the user chooses different parameter values. Is there any way to achieve that in DAX?

Thank you in advance!

[amitchandak · Accepted solution]

@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]

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!

[v-jingzhang]

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!

[karolinaa · Accepted solution]

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!

[amitchandak · Accepted solution]

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