Forum Discussion
Calculated Column Based on Unrelated, Filtered Table
Currently, I have 2 tables : SalesTable and FilterTable. SalesTable is my main data table with 20+ fields, which includes columns called "Price with Tax" and "Price without Tax". FilterTable only con...
Hi Anonymous,
As Greg_Deckler has mentioned above, not like measures, calculate columns/tables are computed during database processing(e.g. data load/refresh) and then stored in the model, they do not response to user selections on the report.
So it is not possible to create a calculate column/table that can change dynamically with user selections on the report. Only the measure can work in this scenario. :smileyhappy:
Regards
Calculated columns are not dynamic within the context of a report. They are essentially calculated at the time of data load. Can't you just use a table visualzation and add in your row identifier and your measure?