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

Joining on tables - ISSUE

I'm in desparate need.  I can't figure out what I need to do to fix the visual.  I'm pretty sure I need to filter or do some sort of dax code that I am not proficient at.  I got a visual that has some data that I have some fields:

Livia_Hernandez_1-1718245527243.png

I added a simple table that I joined on item ID and now one record has like 20 lines.  There is only one record in the table by store / by item that shows the Min:  Max:

Livia_Hernandez_2-1718245691953.png

The Min should be 1 and the max should be 8 but I get all this...  I'm going crazy.  😣

Livia_Hernandez_0-1718245441882.png

 

  Can anyone help me?  

1 ACCEPTED SOLUTION

I did not get the solution to the topic from this post.... BUT - I did get it from another post.  I needed to just merge the 2 tables and it worked!  Thank you all.

View solution in original post

6 REPLIES 6

I did not get the solution to the topic from this post.... BUT - I did get it from another post.  I needed to just merge the 2 tables and it worked!  Thank you all.

Hello @Livia_Hernandez , congradulations on self-solving the issue.   Would you please share the post you mentioned so that other members of the Community may benefit?

 

If your requirement is solved, please make THIS ANSWER a SOLUTION ✔️ and help other users find the solution quickly. Please hit the LIKE 👍 button if this comment helps you.

Ray_Minds
Responsive Resident
Responsive Resident

1. Please check any filter applied in the filter section.
2. Could you please check the relationship columns between two tables. It might be a relationship column not selected correctly.

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Thank you Ray_Minds - It's not any of the filters.  I have removed all as that has got me before.  I'm checking on the relationship columns.  Something is just not working But, I do have a call with a guy who said he would help me.  so... I will post what the solution is regardless.  TY~

aduguid
Super User
Super User

Can you share a screenshot of the join?

Livia_Hernandez_0-1718284813314.png

I'm assuming you mean this?

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.