Table Relationships - getting more column information between two tables

[hsalim]

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 have created a matrix table see below which gives me information on my project code and the revenue each project code made in 2019 and 2020 respectively.

The data stems from the same table called ‘invoices booked’

There is another table from ‘services’ which offers a description (Project-Description) of the name of each projects are, which sectors they belong to etc

If I attempt to recall a column from the ‘services’ table into the matrix table (which is from ‘invoices booked’ already), I receive an error message

This is my table relationships. I’m not quite sure what I’m missing or why it’s generating an error. If someone can help, that would be great thank you

[BA_Pete]

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

[hsalim]

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