Microsoft is giving away 50,000 FREE Microsoft Certification exam vouchers. Get Fabric certified for FREE! Learn more
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.
Hi,
Share some data to work with, explain the question and show the expected result.
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
User | Count |
---|---|
100 | |
68 | |
59 | |
47 | |
46 |