M4nS2211 Tracker

Re: Issue with relationships between 3 tables

M4nS2211 — Tue, 13 Jul 2021 12:41:16 GMT

Seems to be the same issue than this topic : https://community.powerbi.com/t5/Issues/Problem-aggregating-across-many-to-many-link-table-in-Power-BI/idc-p/353921#M21787

Current limitation in Power BI... So I add a measure (count distinct on my Key) on the Table 1 and I will add it each time I need to have a visual with fields from my 3 tables. Very ugly but I need it now ! Hope it'll be resolved in nexts updates...

Re: Issue with relationships between 3 tables

M4nS2211 — Tue, 13 Jul 2021 11:57:14 GMT

Thanks amitchandak ! It works fine. But I'm not satisfied by this behavior. Do you understand why we need to do that ? In SQL I dont' have to summarize any columns to have the good results.

The dataset is for non technical users and the understanding of this manipulation will not be easy...

Issue with relationships between 3 tables

M4nS2211 — Tue, 13 Jul 2021 10:17:41 GMT

Hello,

I have an issue with relationships between 3 tables (Table 1 > *---1 > Table 2 > 1---* > Table 3)

When I combine Table 1 & Table 2 or Table 2 & Table 3 in a visuel it works but I can't add fields from Table 1 & Table 2 & Table 3 in the same visual.

My Key (Id_Espece) is well unique in Table 2. I try it in SQL and it works perfectly.

Give me headache.... Do you have any suggestion for me, to retrieve some hope ? Please help 😄 Thanks