Forum Discussion
Issue with relationships between 3 tables
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...
Super UserM4nS2211 , You can not have ungrouped columns/not summarized from both Table1/Table3 (Many side). Use aggregation like min/max on any one of the table columns, that should work.
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...