Forum Discussion
How to Use Measures in Calculated Columns?
Hi all, I have a report I'm building with a long list of employees, their start date, and end date. I have a slicer that is linked to a date table. I have created two measures based on the slicer...
Calculated columns are only calculated during data refresh so they don't take into account any slicers or filters. If you need something which reacts with slicers and filters you will need to create a measure, not a column.
You can turn your code for a calculated column into a measure by wrapping every column reference in SELECTEDVALUE().