Forum Discussion
Calculated Column/Table Change Dynamically According to Slicer Selection in the Report
Anonymous - Calculated Columns are created and stored in the table when the model is refreshed. The value stored in the row won't change according to the user selection.
What are you trying to accomplish?
Thejeswar, Thanks for the response!
Can you give an example of a dynamic calculated column?
Anonymous - Calculated Columns are created and stored in the table when the model is refreshed. The value stored in the row won't change according to the user selection.
What are you trying to accomplish?
Hi Anonymous,
Thanks for the response! I just want to know if it's possible.
Just to clarify, dynamic selection only works for Calculated Measures and NOT for Calculated Columns and Tables?
Anonymous -
Well, it depends on what you mean, exactly. If you filter for the year 2019, you will actually be filtering all of the rows in the related tables. So in that sense, the selected rows are dynamic, so the table and any calculated columns are dynamic.
But, you are correct that a Measure is calculated at query time, while tables and calculated columns are established prior to the query and don't change - only get filtered.