Forum Discussion
Issue with Displaying Selected Value in Column
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.
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
2 Replies
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.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
