Forum Discussion
Table Relationship Issues
Hi szub
Modified "SERIAL_NBR" column of your "TransactionData" table as below
Create relationships
srial 1 has 1 row record in "Claim" table, serial 1 has 2 rows in "Transaction" table, so wen adding columns from two tables in to a visual, it shows all data from two tables like crossing join.
Best Regards
Maggie
Community Support Team _ Maggie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi v-juanli-msft ,
Thank you for your response. I realized that I did not have a serial number listed more than once in my sample Sales Transaction data once I had left for the day and have now corrected. Thank you for realizing that.
All the training and dicussions I have had with others have advised to stay away using many to many relationships, which is why I did not use it. Are there any negatives that you have experienced with using Many to Many?
Thank you
could you also make a mockup in excel of how you want your table/output to look like?
Hi sturlaws ,
I want to be able to create a visual with detailed claim information only for each transaction serial number that has a claim, like v-juanli-msft replied with. Then, I will need to be able to apply filters from either the transaction or claim table to see the applicable data. I will also be creating quite a few measures like % of serial number sold had claims within xx time frame and do measures/counts on the different claim types. The more I read on the many to many relationship, I think this will work. I am currently trying to validate data to make sure it is correct with the many to many relationship.
Thank you - szub
Hi szub
Your screenshot shows a workaround for many to many relationships for two tables in power bi.
Please see differences between two methods:
Use relationships with a many-many cardinality
One big disadvantage is many to many relationship may slow the performance for the report.
For specific scenario, please use Performance Analyzer to examine report element performance and decide which method to use.
Best Regards
Maggie
Community Support Team _ Maggie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
