Joining on tables - ISSUE

[Livia_Hernandez]

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:

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:

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

  Can anyone help me?  

[Livia_Hernandez · 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.

[foodd]

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]

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.

[Livia_Hernandez]

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]

Can you share a screenshot of the join?

[Livia_Hernandez]

I'm assuming you mean this?