Filter Problem

[MaxiHofer]

Ive got 3 tables: items, posted sales invoices and debitors

Items <- item nr. -> posted sales invoices

posted sales invoices <- debitor nr. -> debitors

The situation is, if I want to filter on this item nr. there is no debitor shown on the left table.

But there is a posted sales invoice with a debitor nr. 

Can anyone help me? I don't know why this happens

[v-eqin-msft]

Hi @MaxiHofer ,

Sorry for that the information you have provided is not making the problem clear to me.

Please provide me with more details about your table(specifically the relationships).

And actually I'd suggest you share me with your pbix file after removing sensitive data , or create a simply data sample with the same structure.

Best Regards,
Eyelyn Qin
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.