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

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
jay007
New Member

Using a table or maxtrix with a linking table relationship

I have used a linking table to perform a many to many join as shown in the following screenshot

example.png

 

Basically I am using the order number to link orders to another subject area and this works for when I apply slicers to the visualisations.

 

However, for use in a  table/matrix visualisation when I try and pull fields from both fact tables, I get the following error:

example2.png

 

From what I can tell - Power BI tables and maxtrix is only smart enough to detect neighboring relationships. 

 

Any help or advice on this would be very helpful.

 

 

 

1 REPLY 1
v-caliao-msft
Employee
Employee

@jay007,

 

I have tested it on my local, when only add key column from two table, I get the same result as yours. However, if I add another measue column to visual, eveything works fine.

Capture.PNGCapture1.PNGCapture2.PNG

 

Regards,

Charlie Liao

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.