RELATED FKT not reporting all available data

[CJC_DB]

Dear all,

first i have to mentoin, that i am pretty new to PowerBI.

I have created two tables which have a 1:1 relationsship.

Anyhow the Related function is not reporting all available data. It does for some rows, but not for all.

I reviewed all datasets but haven't been able to figure out an solution.

Thanks in advance for your help!

[daXtreme]

You should not create 1:1 relationships in your model. Such tables must be consolidated into one since 1-1 means: THE SAME TABLE. So, save yourself the grief and make them into one. By the way, to see why you get what you get one has to have access to the data itself. It's not possible to diagnose a patient without seeing them...

[CJC_DB]

Thank you for the quick reply. The above described issues orccures in "Tabelle1".

I cannot upload the pbix file. DO you have any recomendations how i can uploade a sample file to create better understanding of the issue. Thanks

[Anonymous]

Hi @CJC_DB ,

Could you please provide some sample data in your two tables (exclude sensitive data) with Text format and your expected result with backend logic and special examples? And what's the base field when create the relationship between these two tables?  It is better if you can share a simplified pbix file. You can refer the following link to upload the file to the community. Thank you.

How to upload PBI in Community

Best Regards