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

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
Livia_Hernandez
Frequent Visitor

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
Livia_Hernandez
Frequent Visitor

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
Livia_Hernandez
Frequent Visitor

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
Resolver I
Resolver I

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
Solution Sage
Solution Sage

Can you share a screenshot of the join?

Livia_Hernandez_0-1718284813314.png

I'm assuming you mean this?

Helpful resources

Announcements
July 2024 Power BI Update

Power BI Monthly Update - July 2024

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

July Newsletter

Fabric Community Update - July 2024

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