Available items by supplier?

[Anonymous]

Hi - I have 2 data sources; one is a sales table that has sales by item. Another is the list of all items available (active list), regardless if they have been sold or not. I currently have slicers that allow me to see how many items are in the active list, and how many items are in the sales table as well as the crossover between. 

The issue is that as I change another one of my slicers, the number of active items by supplier doesn't update. It's an accurate value of the total number of active items but I can't figure out how to have it update by supplier. The 2 tables are currently linked by a many:one single way relationship. 

Any suggestions? Is there more information that I can provide? 

[Anonymous · Accepted solution]

I was able to figure it out - I had to re-arrange the relationships between 3 tables and it fired right up.

[parry2k]

@Anonymous sorry not clear what you are looking for? Can you share sample data/screenshots to explain the issue? 

[Anonymous]

Here is how the tables are linked:

This is the card that I want to update when the "Vendor name" slicer is changed. "Vendor name" is a field in both the active item and sales tables, but they are currently linked by APN (item number).