Table Relationship Issues

Question

Hello,&nbsp;I have a sales by serial number and claims by serial number table and the only common field is the serial number.&nbsp; Both tables can have the serial number listed more than once for various reasons, so I created a unique key table with the serial numbers from the sales table only listed once and created a relationship to both tables.&nbsp; When I try to create visuals with information from both tables, I recieve an error that it can't display the visual because it can't determine the relationship between two or more fields.&nbsp;&nbsp;I am looking for suggestions on how I can get claim data visuals for serial numbers sold.&nbsp; I have tried to use LOOKUPVALUE and RELATED or RELATEDTABLE without success, but maybe I am doing something incorrectly.&nbsp;Any suggestions or guidance will be appreciated.&nbsp;Thanks in advance

szub · Answer

Hi&nbsp;sturlaws&nbsp;,&nbsp;I want to be able to create a visual with detailed claim information only for each transaction serial number that has a claim, like&nbsp;v-juanli-msft&nbsp;replied with. Then, I will need to be able to apply filters from either the transaction or claim table to see the applicable data.&nbsp; 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.&nbsp; The more I read on the many to many relationship, I think this will work.&nbsp; I am currently trying to validate data to make sure it is correct with the many to many relationship.&nbsp;Thank you - szub

sturlaws · Answer

Hi&nbsp;szub,&nbsp;do you have a screen shot of your model? Or could you share the report?(upload to onedrive/dropbox/other and share the link).&nbsp;Cheers,Sturla

szub · Answer

Hi&nbsp;sturlaws,&nbsp;Here are the relationships between the tables:&nbsp;&nbsp;&nbsp;Thank You

vastg · Answer

szub&nbsp;&nbsp;Provide sample data for transaction and claims tables.

szub · Answer

Hello&nbsp;VasTg&nbsp;,&nbsp;Here is sample Claim Data:Claim #Claim DateClaim TypeStatusSerial #Svc AgentCustomerFail DateRepair Date# TripsLaborPartsOtherTotalClaim 110/21/2019WarrantyPaidSerial 1SA1Cust110/15/201910/15/20191237.200237.16Claim 212/22/2018InstallationPaidSerial 2SA2Cust212/13/201812/13/20181216.6020.49237.12Claim 35/17/2019WarrantyPaidSerial 2SA2Cust25/14/20195/14/2019125000250Claim 48/22/2019WarrantyPaidSerial 2SA2Cust28/16/20198/16/20191286.247.564.76338.48Claim 59/1/2019InstallationPaidSerial 3SA5Cust38/16/20198/16/20191629.2510511190.12Claim 610/1/2019WarrantyPaidSerial 3SA5Cust310/1/201910/1/2019110020050350&nbsp;Here is sample TransactionData:BRANDInvoice DateSales #Model #ITEM_DESCQtySERIAL_NBRWIDGIT5/20/2019S123Model 1Unit XYZ1Serial 1WIDGIT11/29/2017S123Model 2Unit XYZ1Serial 1WIDGIT11/29/2017S125Model 3Unit XYZ1Serial 2WIDGIT9/20/2019S125Model 4Unit XYZ1Serial 2WIDGIT9/20/2019S127Model 5Unit XYZ1Serial 3WIDGIT10/15/2019S127Model 6Unit XYZ1Serial 4&nbsp;&nbsp;Thank you

Forum Discussion

Table Relationship Issues

9 Replies

Related content

Relationship Issue

Relationship Issue - Keep Filter ISsues.

Date relationship issues

Relationship with Fact tables

Relationship/Slicer Issue