Relation between tables and joining tables problems

[MohTerki]

Hello

I have two tables one named "Requete2" which contains "codejdid" (may contain repititions), "1" and "DATEOPER" and the other table named "table2" which is a calculated  from "Requete2": sum of "1" for the same "codejdid".

The problem is when I change "DATEOPER" it doesn't change from the values of "1" of the table "table2" as showed in this picture

[johnt75]

Calculated tables are only calculated during data load or refresh, they don't pay any attention to slicers or filters. If you want something which will react dynamically you need to use a measure.

[MohTerki]

@johnt75 any help please