Forum Discussion

hsalim's avatar
hsalim
Regular Visitor
5 years ago

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

General Comment
Interesting Links
Need Help
Show and Tell
Tips and Tricks
Tutorial Requests

2 Replies

  • BA_Pete's avatar
    BA_Pete
    Super User
    5 years ago

    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's avatar
      hsalim
      Regular Visitor
      5 years ago

      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