Relationship not working properly

[Anonymous]

 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!

[v-shex-msft]

Hi @Anonymous,

Can you please share your pbix file for further testing?

Regards,

Xiaoxin Sheng

[Anonymous]

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!