Forum Discussion
Selectedvalue, user input
I'm struggling with selectedvalue, I setup a single value slicer to get the user input on productivity ratio.
the labor productivity is reported correctly in the report tab, but when I use the selectedvalue from the slicer for calculation, then always return blank.
my purpose is to selected productivity by user and then calcualte the man-hours needed, and eventually calcualte the cost.
a snapshot as below:
please kindly help, many thanks in advance.
Hi Anonymous
You are using it in a calculated column, this is the cause. Calculated columns are calculated and populated when they are created and refreshed. They are not able to be changed dynamically according to users' interactive behaviors in the report. And your Labor_Productivity_Ratio Value is actually a measure with the default value blank(), so it displays blank() in the column.
To use it dynamically, you should put it in measures or visuals directly. Use measures to calcualte the man-hours and costs instead of calculated columns.
Regards,
Community Support Team _ Jing
If this post helps, please Accept it as the solution to help other members find it.
2 Replies
Hi Anonymous
You are using it in a calculated column, this is the cause. Calculated columns are calculated and populated when they are created and refreshed. They are not able to be changed dynamically according to users' interactive behaviors in the report. And your Labor_Productivity_Ratio Value is actually a measure with the default value blank(), so it displays blank() in the column.
To use it dynamically, you should put it in measures or visuals directly. Use measures to calcualte the man-hours and costs instead of calculated columns.
Regards,
Community Support Team _ Jing
If this post helps, please Accept it as the solution to help other members find it.