Need Help - Keep Filter on multi level Relation Table

[Timuran]

Hey,

I'm trying to keep filter on multi level relation table.

My database for the tables i want to filter look like this:

Tables are link with 'NUMART'.

I'm able to filter on table 'BI_VUE_PRODUIT' depending on value of SPEC in table 'SPEC VALUE'.

Now i want to keep the filter to get rows of table 'public Cube'.

But cause of the relation Many to one -> One To Many I don't know if it's possible and I don't find any topics about this.

Hope you can help me.

Tim

[johnt75 · Accepted solution]

SQLBI have recently released a video which I think you will find useful

[Timuran · Accepted solution]

Hey Johnt,

thank you for your fast answer. Actually it doesn't really help me. I just change my relations to just depend on the two tables i want to filter and it seem to work.

Have a great day.

Tim

[johnt75 · Accepted solution]

SQLBI have recently released a video which I think you will find useful