Forum Discussion

Timuran's avatar
Timuran
Resolver I
3 years ago
Solved

Need Help - Keep Filter on multi level Relation Table

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

  • 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

2 Replies

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

  • 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