Forum Discussion
getting unexpected data in table visual
Hi jmeyer348 ,
According to your description, I created the three tables and created relationships between them.
Then I put some fields in the table visual and used "sold to" of table 2 as a filter. It showed the same results of 4857 and 1357 as you described earlier.
Therefore, please carefully check the relationships between the tables to ensure that they accurately reflect the logical connection between the data. Also check the filters to ensure that the correct rules are used.
If your Current Period does not refer to this, please clarify in a follow-up reply.
Best Regards,
Clara Gong
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi jmeyer348 ,
According to your description, I created the three tables and created relationships between them.
Then I put some fields in the table visual and used "sold to" of table 2 as a filter. It showed the same results of 4857 and 1357 as you described earlier.
Therefore, please carefully check the relationships between the tables to ensure that they accurately reflect the logical connection between the data. Also check the filters to ensure that the correct rules are used.
If your Current Period does not refer to this, please clarify in a follow-up reply.
Best Regards,
Clara Gong
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Thank you for taking a look at it! I think you're right, I also tried creating tables in power BI with the dummy data that I posted here, and I'm seeing the same thing as you, i get only the expected rows. I can't figure out why I'm getting the extra rows when I use the actual data. To me it looks like the same situation, just a bigger dataset. I must be doing something wrong, but unfortunately I can't post the real data here. Anyways I'm sure I'll get it eventually and I appreciate the response!