RELATED FKT not reporting all available data

CJC_DB · ‎11-23-2022

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 · ‎11-23-2022

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 · ‎11-23-2022

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 · ‎11-23-2022

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.