Forum Discussion
Solved
Calculated table afeted by filters o the visuals
Hi, With only the initial balance of the year and all the movements of each month, I have calculated a table where the final balance of each month is calculated and used as initial balance of the...
You can't do it in a calculated table. Tables and columns are only calculated during data load and refresh, they do not pay any attention to slicers or filters.
If you want something to dynamically react to slicers you need to use a measure.
Thanks,
I do not know how to do it with meassures as there are many fields to be accounted for. I will create another question with a simplified example to see If I can get it from there.
Thank you very much.