topic Re: Relationship problem comparing data with a bridge/structure in DAX Commands and Tips

Relationship problem comparing data with a bridge/structure

Anonymous — Sat, 26 Mar 2022 17:55:02 GMT

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

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

Re: Relationship problem comparing data with a bridge/structure

tamerj1 — Sat, 26 Mar 2022 03:44:48 GMT

Hi Anonymous

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

Re: Relationship problem comparing data with a bridge/structure

Anonymous — Sat, 26 Mar 2022 04:16:50 GMT

Values in that example can be price.

This is the result that i expect:

Re: Relationship problem comparing data with a bridge/structure

tamerj1 — Sat, 26 Mar 2022 06:15:49 GMT

Anonymous

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

Re: Relationship problem comparing data with a bridge/structure

Anonymous — Mon, 28 Mar 2022 17:08:52 GMT

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]))

Re: Relationship problem comparing data with a bridge/structure

Anonymous — Sat, 26 Mar 2022 11:59:40 GMT

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:

Re: Relationship problem comparing data with a bridge/structure

tamerj1 — Sat, 26 Mar 2022 13:28:48 GMT

Anonymous

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

Re: Relationship problem comparing data with a bridge/structure

Anonymous — Sat, 26 Mar 2022 16:46:25 GMT

Can you do that in the file attached please?

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