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 

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