Power pivot issue. Filtered model show all invoices

[shophoney]

Hi.

Banging my head against the wall on this.

I have a products table, a sales table and a receivings table.

Everything links back to my products table. But when I add in the invoice field or the sales invoice field. It lists ALL invoices or AL sales. Even though it's a one to many set up.

If i created a "RELATED([model]) in both it works fine. But then I have a filtered MODEL in all 3 tables. and then my slicers wont work.

I hope i made this clear. Thanks for reading.

 

[Matt Allington]

Chances are that you are using the wrong columns in your pivots. If sales table and receives table both link to products table, then ONLY use columns from the products table in your pivots.