Forum Discussion

o59393's avatar
o59393
Post Prodigy
2 years ago

Calculated Column displaying duplicate values

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.
Need Help
Show and Tell

2 Replies

  • Greg_Deckler's avatar
    Greg_Deckler
    Community Champion
    2 years ago

    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's avatar
      o59393
      Post Prodigy
      2 years ago

      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.