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: