Forum Discussion
Getting total in every line
Hi,
I have 3 tables, contacts (left side below), company (middle) and membership (right). I created a row count measure from the company table to count the number of contacts per company -> RowCount = COUNTROWS(Contacts). This works fine for the company table.
When I add this measure to the membership table on the right, I get a value of 5 in each row instead of the values in the middle table that I want.
The relationships are setup as follows:
Any clues please?
It's definitely a relationship problem. The filtering is not working and it's probably to do with relationship direction.
Can you show a picture of the relationship model?
3 Replies
It's definitely a relationship problem. The filtering is not working and it's probably to do with relationship direction.
Can you show a picture of the relationship model?
Here are the relationships.
@byrdwatcher1978 you dont have to create a measure to get the count of company...You can make use of
And also as per the screen shot which you have shared since Membership table cant filter with contacts it is showing same data for all the rows...Try doing by selecting bi-direction in power bi ..
