Connecting 2 different sums in Dim and Fct Table between Hierarchy
Hello Guys, I have Fct_Amortized_Cost table and Dim_EA_SavingsPlans. They are connected with 1 to many relationship like here: the issue is that i am trying to use hierarchy : MeterCategory--> MeterSubcategory from Fct table and show CommitmentAmount per day: ROUND(sp.Commitment_Amount * 24, 2) AS "Commitment_Amount_Per_Day", this is sql for it. CommitmentAmount is in Dim table. the issue is that i am not seeing proper values when building Matrix visual. I have build a dax: Commitment_Amount_Per_Day = ROUND(SUM(Dim_EA_SavingPlans[Commitment_Amount]) * 24, 2) but when i am doing matrix i am not seeing proper results. Core Issue: No filter context propagation Your matrix uses MeterCategory, MeterSubCategory, and potentially ResourceType — these fields: Come from other tables (not Dim_EA_SavingPlans) Are not directly related to Dim_EA_SavingPlans Therefore, do not filter Dim_EA_SavingPlans, even if they are part of a visual So SUM(Dim_EA_SavingPlans[Commitment_Amount]) just adds up everything from the entire table on every row — unless a DisplayName or ID from Dim_EA_SavingPlans is in the visual. this is explanation from chatgpt. But how to make this properly? Best, Jacek
