Forum Discussion
Table Relationships - getting more column information between two tables
Hi everyone I found these forums extremely useful and thank you to all your help and contributions. It’s helping me to become a much better DAX / Power BI user. I reached another stumbling block. I...
Hi hsalim ,
I believe this is because your filter direction between Services and Append2 do not allow filters to propogate FROM Services TO Append2 then onto Invoices booked.
Right click on this relationship and change the filter direction to BOTH:
This should allow the filter to flow correctly as you require. However, be mindful that this will also allow any filters applied to Append1 to propogate to Invoices Booked as well.
Pete
Hi BA_Pete
Thank you for your help
I changed it to BOTH and this time it did provide me Project Descriptions but all the descriptions are the same:
What could be the reasons for that please?
Thanks