Skip to main content
Showing results for 
Search instead for 
Did you mean: 

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

Responsive Resident
Responsive Resident

Relationships not working

Hello Community. I have a problem with a relationship that I guess could be the cause of my problem. So I needed two columns that were on different tables. So after merging using a Primary Key, and loading the column I wanted on a table, I am experiencing that or some values are correct in the table visual for that column. However, other values, bring the total in the table visual for the same column. The Visual table(Report Tab) below shows what I am explaining:

Primary Keycolumn1FromTable1(text) column2FromTable1(text)column3FromTable1(text)column1FromTable2(Value)column2FromTable2(Date)column3FromTable1(Column of interest)
1CLient AProduct AState ARevenueAForecastprojectcloseDate139456
2Client BProduct BState B RevenueBForecastprojectcloseDate234662
3Client CProduct CState C RevenueCForecastprojectcloseDate3



4Client Dproduct AStateBRevenueDForecastprojectcloseDate2


5Client Eproduct CState DRevenue BForecastProjectCloseDate4


6Client Fproduct BState E Revenue EForecastProjectCLoseDate1


As you can see for Primary key 4 and 6 , the far end column on the VIsual table has a very high value. This value is the total for that column. I am more used to the total showing for the whole column when a relationship does not work. But now this relationship is somewhat working partially. Any ideas to solve this?

Community Support
Community Support

Hi @Datagulf ,

Could you pls share your pbix file ,and remember to remove confiential data.

You can also check if there are spaces in the fields, which is why some of the relationships don't work, alternatively you can refer to: 



Best Regards


Super User
Super User

Please show more information - show your current data model for example.

Helpful resources

RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.


Power BI Monthly Update - May 2024

Check out the May 2024 Power BI update to learn about new features.


Fabric certifications survey

Certification feedback opportunity for the community.