Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

Relationship problem comparing data with a bridge/structure

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" 

CarCompanyValue
AX2


"DATA_2"

CarValue
A1

 

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

 

  • Anonymous's avatar
    Anonymous
    4 years ago


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

     

     

     

     



7 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago


    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's avatar
    tamerj1
    Icon for Community Champion rankCommunity Champion
    4 years ago

    Hi Anonymous 

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

    • Anonymous's avatar
      Anonymous
      Not applicable
      4 years ago

      Values in that example can be price.

       

      This is the result that i expect:

       

       

      • tamerj1's avatar
        tamerj1
        Icon for Community Champion rankCommunity Champion
        4 years ago

        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