Forum Discussion
Tallyski
3 years agoAdvocate I
Relationship Issue - Power Bi
After creating a relationship between two tables, I am having trouble with a count.
The count should be:
But I see:
The relationship is built on the event_log_id, and I use that to make the count.:
I've tried all types of relationships, but it doesn't seem to work. Any help would be appreciated.
2 Replies
- djurecicSuper User
Hi Tallyski ,
You should avoid many to many relationships if possible. Could you possibly create a table with unique event_log_id as a bridge table and join each table to it?
Here is some additional information:
https://learn.microsoft.com/en-us/power-bi/guidance/relationships-many-to-many
- Ashish_MathurSuper User
Hi,
Share some data to work with, explain the question and show the expected result.