Calculated table afeted by filters o the visuals

[Pastor84]

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 subsequente month.

My problem is that I want to show how different versions of the monthly movements can and will affect these final-initial balances. 

The selection of the version has to be at "user level" while navigating the report, so probably though a slicer on teh canvas But I do not know how to make this slection in the canvas afect the calculation of the table.

The table with all the movements has a field wher teh version of the data is identified. I can relate this field with the table of the balances but I do not know how to make the calculation depend on a filter of the visual.

[Pastor84]

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.

[johnt75 · Accepted solution]

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.