Selectedvalue shows blank in column

[Anonymous]

Hello everyone:

I have this problem,

I have a table with a column Sheet1 [distance]  with number values from 0 to 200, in a drop down list.

I have another table with another column like this:
BUSCAR= SELECTEDVALUE (Sheet1 [distance])

The problem is that the Find column is blank

Any ideas?

Thank you!

[v-eqin-msft]

Hi @Anonymous ,

Sorry to disturb you...

Could you tell me if your problem has been solved? If it is, kindly Accept it as the solution. More people will benefit from it. Thank you

Best Regards,
Eyelyn Qin

[v-eqin-msft]

Hi @Anonymous ,

Calculated columns could not be dynamic. So as @amitchandak , you could use measure instead.

Slicers cannot be used in calculated columns. They can, however, be used in measures. Slicers are Filters, and thus use filter context. Filters can change dynamically based on what is selected, and how filter interactions are defined.

Did I answer your question ? Please mark my reply as solution. Thank you very much.

Best Regards,
Eyelyn Qin

[amitchandak]

@Anonymous , You can not create a column with selectedvalue of slicer/column. You can only use that in a measure