Forum Discussion
Helper IJoining 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:
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?
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.
6 Replies
- aduguid
Memorable Member
Can you share a screenshot of the join?
Livia_HernandezI'm assuming you mean this?
- Ray_Minds
Solution Supplier
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~
- Livia_Hernandez
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
Community Champion
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.
