cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Tallyski
Frequent Visitor

Relationship Issue - Power Bi

After creating a relationship between two tables, I am having trouble with a count. 

The count should be:
Count2.PNG

But I see:
Count1.PNG

The relationship is built on the event_log_id, and I use that to make the count.:
Relationship1.PNG

I've tried all types of relationships, but it doesn't seem to work. Any help would be appreciated.

2 REPLIES 2
Ashish_Mathur
Super User
Super User

Hi,

Share some data to work with, explain the question and show the expected result.


Regards,
Ashish Mathur
http://www.ashishmathur.com
https://www.linkedin.com/in/excelenthusiasts/
djurecicK2
Resident Rockstar
Resident Rockstar

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

 


If this post helps, then please consider accepting it as the solution to help other members find it more quickly.

Helpful resources

Announcements
May 2023 update

Power BI May 2023 Update

Find out more about the May 2023 update.

Submit your Data Story

Data Stories Gallery

Share your Data Story with the Community in the Data Stories Gallery.

Top Solution Authors