Join not recognized

[aryank2000]

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.

[v-piga-msft]

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