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

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