Hi @Alireza_Bavafa,
Do you mean that your join is creating duplicate values and causing your aggregations to give incorrect results? Use case #2 in this article shows you how to use level-aware calculations to deduplicate data.