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

     

     

     

     



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

    • Anonymous's avatar
      Anonymous
      Not applicable
      4 years ago

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

        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