Forum Discussion
AbdelrahmanAyad
8 years agoFrequent Visitor
USE Value in SelectedValue() as column
Hey Guys, I have a problem , I have a report filter for the date. So I want to use the value selected by the user as the value for a fact table for example if the user selected '1/1/2017' I want ...
- 8 years ago
Anonymous
8 years agoNot applicable
Calculated columns are calculated only ONCE, AT REFRESH. They do not change in response to measures, or slicer selections.
AbdelrahmanAyad
8 years agoFrequent Visitor
Thank you for your great response, but do you know if there is a possible way to capture the selected value and keep using it in multiple statements. For example, Lets assume i selected 1/1/2017 i want capture this value and use it in other tables neglecting the other relations for instance if used it in fact table to filter the rows to perform on lookup helps , as if i tried to create a measure = selectedvalue(calendar) date and i use in my expression : FactTAble[date] = measure the measure automically takes the value of the date field of the table column
- v-yulgu-msft8 years ago
Microsoft Employee