Forum Discussion
Helper VRelationship Issue
hello Hussein_charif
as mentioned by rohit1991 , the problem with many-to-many is power bi can not tell which to which when you have repeating id.
sharing my experience for many-to-many relationship in my previous project, i created a calculated column in both table for "dummy" unique id which come from concatenate two column.
this way is better than having relationship only from one column which has repeating id.
Hope this will help.
Thank you.
Helper VHello, i have tried this, i couldnt get the amounts to show for the categories and subcategories, i was getting an error that there is no relationship between the fields (i am using fields from the structure table[category and subcategory] and the amount from the journal table), even if i put the ID under the categories and subcategories in my matrix. the only way it showed the amounts was when i put the ID at the first level of the matrix, but even then if i go down the levels to the categories and subcategories i get 0 amounts
Super Userhello Hussein_charif
as mentioned by rohit1991 , the problem with many-to-many is power bi can not tell which to which when you have repeating id.
sharing my experience for many-to-many relationship in my previous project, i created a calculated column in both table for "dummy" unique id which come from concatenate two column.
this way is better than having relationship only from one column which has repeating id.
Hope this will help.
Thank you.