Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
8 years ago

Relationship not working properly

 Hello,

 

I am hoping someone can help.  I have a table that I need to add icons to in order to represent the sales level of a particular customer.  I have a link created between my main table and my icon table using an id that is calculated in the main table in order to join to the correct icon in my icon table.  You can see the screenshot of the relationship above and the resulting dataset below.  Notice that all of the available icons appear for each customer, but the correct one is noted in the "level" column and is actually associated with some monetary values.  What is wrong with my relationship settings?  Any help would be appreciated!

 

 

2 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable

    Hi Anonymous,

     

    Can you please share your pbix file for further testing?

     

    Regards,

    Xiaoxin Sheng

    • Anonymous's avatar
      Anonymous
      Not applicable

      Thanks, I was able to locate source of the problem: an if statement in a different column could have more than one positive result.

       

      Thanks again for your input!