Relationship problem comparing data with a bridge/structure

[Denis_Araujo]

Hi, I haven't quite found my exact issue in an existing forum post; if there's something already out there on this topic I'd be happy to take a look.

My problem is related to relationship, as you can see in the sample bellow, just "DATA_1" has the "Company" information and when i try to compare thoses values i got undesired output from my matrix visual;

"DATA_1" 

Car	Company	Value
A	X	2

"DATA_2"

Car	Value
A	1

Bridge/Structure:

Car

A

B

The Result of Matrix (Incorrect):

And i would like to have that result:

Relationship:

OBS: Merging "DATA_1" with "DATA_2" can solve but is not an option in my real project.

Folder With .pbix file: https://drive.google.com/drive/folders/1EaALoubhWaydbhOvYCdMY2gO_sxjBAZ6?usp=sharing

[Denis_Araujo · Accepted solution]

I find a solution with DAX, the measure bellow ensures that the values dosent repeat with N:N relationship in the rows of my matrix:

Measure_Value_DATA_2 = IF(not ISFILTERED(DATA_1[Company]),SUM(DATA_2[Value]))

[tamerj1]

Hi @Denis_Araujo 

what are Value_A and Value_B? Can you clarify further the expected Result?

[Denis_Araujo]

Values in that example can be price.

This is the result that i expect:

[tamerj1]

@Denis_Araujo

The column must exist the table even if it was blank. Even if the column exists you still need to have have a common filter table which can be easily created in Powerbi

[Denis_Araujo]

What you are trying to say with a common filter, is that just visual filter "company"?

I just test right know the same sample with all of them with the same collumns and the problem persist:

[tamerj1]

@Denis_Araujo 

I mean local table that contains all unique cars and other one that contains all unique companies. Build the relationships with the two company columns and the two car columns using the these tables thes use them in the visual

[Denis_Araujo]

Can you do that in the file attached please?

https://drive.google.com/drive/folders/1EaALoubhWaydbhOvYCdMY2gO_sxjBAZ6?usp=sharing