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.
Go to Solution.
SQLBI have recently released a video which I think you will find useful
View solution in original post
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.
Take a look at the September 2023 Power BI update to learn more.
Join Microsoft Reactor and learn from developers.