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.
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:
Check out the changes to the Power BI Community announced at Build.
Find out more about the May 2023 update.
Visit our Data Stories Gallery and give kudos to your favorite Data Stories.