this is my first topic as my search on several forums did not solve my problem.
I have the datamodel below where I have 2 FACT tables and 3 DIMENSION tables where of 2 are linked to both fact tables, 1 (MD_GL) is only linked to 1 fact table (Fact_cost)
And I have now following issue: when I use data from the dimension table (MD_GL) and use data from the other FACT table (Fact_Volume), then I got a list of all the dimensions of the dimension table.
= CALCULATE([SumOfVolume];FILTER(Fact_Volume;Fact_Volume[Type] = “Loaded”))
= CALCULATE([SumOfValue];FILTER(Fact_Cost;Fact_Cost[GeneralLedgerAccountCode]<>“5220001200”);FILTER(Fact_Cost;Fact_Cost[GeneralLedgerAccountCode] <> “6460001100”))
Can someone help how I can solve this or do I have to create 1 FACT table or do I have the filter the dimension table (MD_GL) based on the content of the fact table (Fact_Cost) ?
Thanks already in advance,