cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Timuran
Helper I
Helper I

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:

Timuran_0-1669218084408.png

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

2 ACCEPTED SOLUTIONS
johnt75
Super User
Super User

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

View solution in original post

Timuran
Helper I
Helper I

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

View solution in original post

2 REPLIES 2
Timuran
Helper I
Helper I

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
Super User
Super User

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

Helpful resources

Announcements
May 2023 update

Power BI May 2023 Update

Find out more about the May 2023 update.

Submit your Data Story

Data Stories Gallery

Share your Data Story with the Community in the Data Stories Gallery.

Top Solution Authors