Forum Discussion

MohTerki's avatar
MohTerki
Regular Visitor
3 years ago

Relation between tables and joining tables problems

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

 

Need Help

2 Replies

  • johnt75's avatar
    johnt75
    Icon for Super User rankSuper User
    3 years ago

    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.