topic Re: RELATED FKT not reporting all available data in DAX Commands and Tips

RELATED FKT not reporting all available data

CJC_DB — Wed, 23 Nov 2022 10:31:38 GMT

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!

Re: RELATED FKT not reporting all available data

daXtreme — Wed, 23 Nov 2022 10:56:44 GMT

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...

Re: RELATED FKT not reporting all available data

CJC_DB — Wed, 23 Nov 2022 14:22:31 GMT

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

Re: RELATED FKT not reporting all available data

Anonymous — Thu, 24 Nov 2022 07:44:46 GMT

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