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!
Can you please share your pbix file for further testing?