Return Selected Value in calculated Column

[Anonymous]

Hi everyone!

Is there anyway to return a selected value in a calculated column? 

When i try this the column just return blank.

[Greg_Deckler · Accepted solution]

@Anonymous No. Colums are calculated at the time of data refresh/load and thus cannot be influenced by user interaction. You will need to use a measure.

[amitchandak · Accepted solution]

@Anonymous , No can not use slicer value can not be used in a column. You need to think it the term of measure. Try to use the row context to get the right calculation.

Like in this values/summarize has been used to push row context in date diff calculations https://community.powerbi.com/t5/Community-Blog/Decoding-Direct-Query-in-Power-BI-Part-2-Date-Difference-Across/ba-p/934397#M451

[Greg_Deckler · Accepted solution]

@Anonymous No. Colums are calculated at the time of data refresh/load and thus cannot be influenced by user interaction. You will need to use a measure.