Dimension Table Relationship Not Working

Hi R_Username ,

Please have a try.

1. Open the "Manage Relationships" window in Power BI by clicking on the "Manage Relationships" button in the "Modeling" tab.

2. Check that the relationship between your dimension table and your two queries is set up correctly. Specifically, ensure that the "PROGRAMME.CODE" column in your dimension table is related to the "PROGRAMME.CODE" column in your two queries.

3. If the relationship is not set up correctly, you can edit it by clicking on the relationship arrow and adjusting the columns that are used for the relationship.

4. Once the relationship is set up correctly, try adding the "PROGRAMME.TITLE" column from your dimension table to your matrix table. This should display the programme titles instead of the programme codes.

How to Get Your Question Answered Quickly 

If it does not help, please provide more details with your desired output and pbix file without privacy information (or some sample data) .

Best Regards
Community Support Team _ Rongtie

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.