Issue with Displaying Selected Value in Column

[Shahul_MRL]

Dear Team,

I am reaching out regarding a challenge I am facing with retrieving the selected value in a specific column. Despite selecting "PRI" in the slicer, the column values continue to display as "Stockin" only.
Cohort column is in the slicer so will be giving the option to user to select stockin or PRI.

Your assistance in resolving this matter would be greatly appreciated.

[Shahul_MRL]

Tried this 

Cohort Selected = IF(SELECTEDVALUE('Cohort Support'[Cohort])="PRI","PRI","Stockin") and result is Stockin only all time.
and for Cohort Selected = SELECTEDVALUE('Cohort Support'[Cohort]) balnk is the result.

[v-yiruan-msft · Accepted solution]

Hi @Shahul_MRL ,

It seems that what you are creating is a calculated column, the calculated column will not change according to the user interaction(slicer, filter, column selections etc.) in the report as the value of a calculated column is computed during data refresh and uses the current row as a context... Please review the following links about the difference of calculated column and measure...

Calculated Columns and Measures in DAX

Calculated Columns vs Measures

You can create a measure as below with the same formula, it can achieve your expected result.

Cohort Selected = IF(SELECTEDVALUE('Cohort Support'[Cohort])="PRI","PRI","Stockin")

Best Regards