Forum Discussion
giroldoale
6 years agoHelper I
Datatable filter -> LookupTable does not work
Hi everyone, I have two tables: - datatable - lookuptable. The datatable is already linked to the order quantity values from the lookuptable in PowerQuery queries. In addition, I have a relation...
amitchandak
6 years agoSuper User
giroldoale , Not very clear to me
your filter is not bi-direction so it will filter from Ordin.. to Fin.. not from fin to ordin..
Make join Bi-directional and check
giroldoale
6 years agoHelper I
Hi amitchandak thanks for the reply..
how can I reach the bidirectional relation?
- amitchandak6 years agoSuper User
giroldoale , refer
https://docs.microsoft.com/en-us/power-bi/transform-model/desktop-bidirectional-filtering
- giroldoale6 years agoHelper I
There is only one point that is not so clear. I do not understand the value of a flag into "Apply security filter in both directions" what's happen if it's flagged or not?
thanks