Forum Discussion
Dynamic calculated column based on slicer selection
Hi Vennela ,
I'm afraid that creating calculated columns doesn't do what you want (dynamically displaying values based on slicer selection). As amitchandak said, creating a calculated column can't get the values selected by the slicer. You can check the following blogs for the answer...
Calculated Columns and Measures in DAX
Calculated Columns vs Measures
There is a big difference between calculated columns and measures. The value of a calculated column is computed during data refresh and uses the current row as a context; it does not depend on user interaction in the report. A measure operates on aggregations of data defined by the current context, which depends on the filter applied in the report – such as slicer, rows, and columns selection in a pivot table, or axes and filters applied to a chart.
Best Regards
Hi amitchandak, Thanks for your response. your solution is working if I create a measure. I can see the grand total showing the sum of the field.
But, is there a workaround to create a column instead of a measure? as I have to use this column in further calculations which would be at row level hence, it should be a calculated column.
Hi Vennela ,
I'm afraid that creating calculated columns doesn't do what you want (dynamically displaying values based on slicer selection). As amitchandak said, creating a calculated column can't get the values selected by the slicer. You can check the following blogs for the answer...
Calculated Columns and Measures in DAX
Calculated Columns vs Measures
There is a big difference between calculated columns and measures. The value of a calculated column is computed during data refresh and uses the current row as a context; it does not depend on user interaction in the report. A measure operates on aggregations of data defined by the current context, which depends on the filter applied in the report – such as slicer, rows, and columns selection in a pivot table, or axes and filters applied to a chart.
Best Regards