Calculated Column displaying duplicate values

[o59393]

Hi all

I have a calculated column that is repating the value per row when it should be different:

The calculated column named "W" is a multiplication of X, Y and Z. But as you can see, the rows of the column W are repeated and should not. The correct value is show in the column AA (calculated measure)

I attach a sample model of the example described in the image: Sample_demand.pbix

How can I get the calculated column W show the same values as column AA?

Thanks.

[Greg_Deckler]

@o59393 Well, you have a weak many-to-many relationship between the two tables involved and that's probably a starting point for what is going wrong. 

[o59393]

Hi @Greg_Deckler !

Yes I know M:M is not recommeneded, however is the only way I can treat my model because it has multiple SKU's, which then I cluster them by categories.

The source files inevitably lead me to make a M:M relationship.

If you could find a turnaroud to my calculated column I would appreaciate 🙂

Thanks.