Forum Discussion

DreDre's avatar
DreDre
Helper II
4 years ago
Solved

Calculated column error for duplicate value but no reference

I am running into an issuse with a report I created and I would appreciate any feedback.    I have been working with a subset of my data to reduce refresh time as I built a new report. With my rela...
Need Help
  • TheoC's avatar
    TheoC
    4 years ago

    Hi DreDre 

     

    From my understanding, the error is saying that there is duplicate value in the Table[Column] you're referring to and that particular column is being used as the relationship to another Table2[Column2]. And because you are using Table[Column] as the relationship (the "one" in the one to many), Power BI is pulling an error.

     

    Although it's not best practice, can you go to your Data Model and switch the relationship from One to Many to Many to Many and see what happens?  

     

    Theo 🙂

     

  • DreDre's avatar
    DreDre
    4 years ago

    This issuse was actually a problem with my data. The relationship needed to be many to many, but I was missing the secondary relationship that also needed to be adjsuted. Once I changed both relationships this fixed my issue! Thank-you for those that answered, I appreciate the help!

TheoC's avatar
TheoC
Community Champion
4 years ago

Hi DreDre 

 

From my understanding, the error is saying that there is duplicate value in the Table[Column] you're referring to and that particular column is being used as the relationship to another Table2[Column2]. And because you are using Table[Column] as the relationship (the "one" in the one to many), Power BI is pulling an error.

 

Although it's not best practice, can you go to your Data Model and switch the relationship from One to Many to Many to Many and see what happens?  

 

Theo 🙂

 

DreDre's avatar
DreDre
Helper II
4 years ago

I was able to find the error in excel and it is something that is needed by design. But I missed the second releationship associated to this column! I switched both of these to many to many and it works! Than-you for the suggestion TheoC !