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
aishak12
Helper IV
Helper IV

Many to Many Relationship

All,

 

I have this relationship between two tables. I have a question

 

If the top table does not have a record in the bottom table, what will happen? 

 

I do not want any data removed or missing. Will it just populate a blank row for table 2 if nothing matches the value? 

 

1 REPLY 1
gauthamboppana
Solution Specialist
Solution Specialist

Hey @aishak12  - Depends on your visual, measure and the cross filter direction.  Can you add some screenshots of your visual and also what's your filter direction?

gauthamboppana_0-1661191191589.png



Did I answer your question? Mark my post as a solution! If not, please feel free to ask me.

Also, I would ❤ Kudos if my solution helped.  It is a token of appreciation!

Thank you very much !

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.

Top Solution Authors
Top Kudoed Authors