Skip to main content
cancel
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.

Reply
Philip_L
New Member

Relationship without filtering

I have two datasets simular to below. I need to put into a single table visual. 

1.jpg

What I want is this...

2.jpg

but what I get is this...

3.jpg

I've tried a 1:* and *:* and I get the same results.

What am I doing wrong? Any help would be greatly apprecaited.

1 ACCEPTED SOLUTION
TheoC
Super User
Super User

Hi @Philip_L 

 

Here is what you are wanting mate. I just posted a fresh reply so that it cleans up the comments, etc.

 

TheoC_3-1635810397027.png

 

If I have posted a response that resolves your question, please accept it as a solution to formally close the post.

Also, if you are as passionate about Power BI, DAX and data as I am, please feel free to reach out if you have any questions, queries, or if you simply want to connect and talk to another data geek!

Want to connect?www.linkedin.com/in/theoconias

View solution in original post

5 REPLIES 5
TheoC
Super User
Super User

Hi @Philip_L 

 

Here is what you are wanting mate. I just posted a fresh reply so that it cleans up the comments, etc.

 

TheoC_3-1635810397027.png

 

If I have posted a response that resolves your question, please accept it as a solution to formally close the post.

Also, if you are as passionate about Power BI, DAX and data as I am, please feel free to reach out if you have any questions, queries, or if you simply want to connect and talk to another data geek!

Want to connect?www.linkedin.com/in/theoconias

TheoC
Super User
Super User

Hi @Philip_L 

 

Ensure that the Key from Dataset 1 is the ONE and the Key from Dataset 2 is the MANY.  Have a SINGLE direction relationship from Dataset 1 to Dataset 2.

 

Use the Dataset 1 Key in Column 1. Use Dataset 1 Name in Column 2. Use Dataset 2 in Column 3.

 

Also, ensure that you do not have any filters on for State being blank.  Check your visual and the filter pane and make sure that State does not have any filters 🙂

 

If I have posted a response that resolves your question, please accept it as a solution to formally close the post.

Also, if you are as passionate about Power BI, DAX and data as I am, please feel free to reach out if you have any questions, queries, or if you simply want to connect and talk to another data geek!

Want to connect?www.linkedin.com/in/theoconias

Thanks for the response. Unfortunately thats how I have it setup already. I am still getting the same filtered results which is why I am not sure whats happening.

@Philip_L my apologies!  I misread your output, all you need to do is press "Show Items With No Data" on the Key / State / Name fields 🙂

 

TheoC_0-1635810089638.png

 

If I have posted a response that resolves your question, please accept it as a solution to formally close the post.

Also, if you are as passionate about Power BI, DAX and data as I am, please feel free to reach out if you have any questions, queries, or if you simply want to connect and talk to another data geek!

Want to connect?www.linkedin.com/in/theoconias

TheoC_2-1635810348881.png

Hope this helps 🙂

 

 

 

If I have posted a response that resolves your question, please accept it as a solution to formally close the post.

Also, if you are as passionate about Power BI, DAX and data as I am, please feel free to reach out if you have any questions, queries, or if you simply want to connect and talk to another data geek!

Want to connect?www.linkedin.com/in/theoconias

Helpful resources

Announcements
RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

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

MayPowerBICarousel

Power BI Monthly Update - May 2024

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

LearnSurvey

Fabric certifications survey

Certification feedback opportunity for the community.