Forum Discussion
Issue with Displaying Selected Value in Column
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
Tried this
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