Data omit issue while using one to many relationship

[Anonymous]

I have added two tables in Power BI with one to many relationship, Added fields from both tables. But If the related data is not available in second table, then the data from the first table is not showing in the table. Please help. 

[Ashish_Mathur]

Hi,

Share some data, explain the question and show the expected result.

[Anonymous]

https://drive.google.com/file/d/18BRxeuBptzCPp_kr7_Z8nZD9G1tS0V9E/view?usp=sharing 

I have shared pbix file with sample data. Please check @Ashish_Mathur 

[Ashish_Mathur]

Hi,

I do not know what you are trying to do or what those 3 different datasets represent.  I think you should first standardise the headings in the 2 datasets - INV Qty and PL Qty and then append those datasets.  Then create a relationship (Many to One and Single) between the Inv column of the appended dataset and the SO Qty table.

Hope this helps.

[Anonymous]

@Ashish_Mathur Sorry, I have re uploaded pbix file. My issue was resolved by merging two tables using using left join. Any alternative method available. This will increase my dataset size.

[Ashish_Mathur]

Hi,

You can try my method.

[Anonymous]

Hi @Anonymous ,

If there are two model relationships between the two tables? Please ensure it is using active relationship.

Please refer to the following document.

https://docs.microsoft.com/en-us/power-bi/guidance/relationships-active-inactive

Best Regards

Community Support Team _ Polly

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.