Forum Discussion

aryank2000's avatar
aryank2000
Frequent Visitor
7 years ago

Join not recognized

Hi,

 

I have the following relation

 

Dim1 (1.n) --> Fact1 (1..n) --> Fact  (n.1) --> Dim2

 

When I drag measures from Fact1, Columns from Dim2, the measure values in Fact1 are not split up by attribute values in Dim2. In other words, the same total amount is repeated across all attribute values. I suspect the join between Dim2 and Fact1 is not recognized. Any idea what could be the issue? I'm calculating totals.

Need Help

1 Reply

  • v-piga-msft's avatar
    v-piga-msft
    Resident Rockstar
    7 years ago

    Hi aryank2000 ,

    To understand your scenario better, please share some data sample and your desired output so that we could help further on it.

    Best  Regards,

    Cherry