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

The Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.

Reply
rpinxt
Power Participant
Power Participant

Connecting 2 tables thru a master data table

I have this setup :

rpinxt_0-1698759343124.png

MD_Carrier is de master data table with which I connect table 1, Case, with table 2, ForwardersDPMO.

Done these things before and always worked just fine.

However now strange things are going on.

 

These are the carrier in all 3 tables separate :

rpinxt_1-1698759452090.png

As you see Table 1 has more than the MD table but that should not be a problem.

And table 2 has exactly the same Carriers as the MD (table 2 was the input for making the MD table)

 

Normally you would be able to put all these fields in 1 table right?

Well if I have from MD carrier and from table 2 Forwarder in 1 table :

rpinxt_2-1698759682966.png

What causes this?

Because this also gives me stange numbers or no numbers if I use the MD carrier in visuals and pull in amounts from table 2 and fields from table 1.

 

 

1 ACCEPTED SOLUTION
rpinxt
Power Participant
Power Participant

Well still not sure what was going one.

But once I deleted the master data table and put a new one in that was alphabettical all was good again....

🤔

View solution in original post

1 REPLY 1
rpinxt
Power Participant
Power Participant

Well still not sure what was going one.

But once I deleted the master data table and put a new one in that was alphabettical all was good again....

🤔

Helpful resources

Announcements
Feb2025 Sticker Challenge

Join our Community Sticker Challenge 2025

If you love stickers, then you will definitely want to check out our Community Sticker Challenge!

Jan NL Carousel

Fabric Community Update - January 2025

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