Forum Discussion

FabianHolm's avatar
FabianHolm
New Member
11 months ago
Solved

Modelling

Hi all, I’m working with a semantic model provided by our data engineers and trying to extend it using a composite model in Power BI. Here’s the setup: I’m importing a dimension table I created ...
Need Help
  • Royel's avatar
    Royel
    11 months ago

    Hi  FabianHolm  seems like the relationship beteen MaterialDim to FactTable is not set properly. As its a dimension and Fact table relationship if possible try to make it 1 to many.

     

    If i implement your model with same sample data it will be look like this 

    Here: Relationships are 

    ESG[CatNum] = MaterialDim[CatNum] 

    MaterialDim[Key] = FactTable[Key]

     

    Measure: 

    MyVal1 = CALCULATE(SUM(FactTable[Val1]), FILTER(ESG, ESG[Name] = "Cat1"))

    Results: 

     

    As you can see i got 13 (11 + 2) for Cat1 which is correct. 

     

    Idea:

    • Keep 1-1 relationship between ESG and MaterialDim 
    • Make sure MaterialDim (Key) column is unique and relationship is 1 to many (ideal) 

     

    Let me know what is the different situation you have? 

    Thanks 

rajendraongole1's avatar
rajendraongole1
Icon for Super User rankSuper User
11 months ago

Hi FabianHolm - Create a relationship ESG → MaterialDim

Make sure ESG[CatNam] and MaterialDim[CatNam] have the same cleaned values.

In the model, drag a relationship between them (likely many-to-one, ESG → MaterialDim).

Then, relationships will flow:
FactTable → MaterialDim → ESG.

This works if you want ESG categories to filter down into FactTable.

 

try the above logic, and let us know.