Hi all,

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.

Measures

Volume Loaded

= CALCULATE([SumOfVolume];FILTER(Fact_Volume;Fact_Volume[Type] = “Loaded”))

Cost

= CALCULATE([SumOfValue];FILTER(Fact_Cost;Fact_Cost[GeneralLedgerAccountCode]<>“5220001200”);FILTER(Fact_Cost;Fact_Cost[GeneralLedgerAccountCode] <> “6460001100”))

UCPT_Loaded

= DIVIDE([Cost];DIVIDE([VolumeLoaded];1000))

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,

Jan