Forum Discussion

Ruksuro's avatar
Ruksuro
Helper III
9 years ago
Solved

Many to Many Measure

Hi Community,   I have created a many-many structure in desktop by creating a bridging table which contains only the distinct values of the joining column.   I would like to create a measure whic...
Need Help
  • Ruksuro's avatar
    Ruksuro
    9 years ago

    Hi Tom,

     

    The act of producing a simplified model help the solution come to me! 

     

    I simply needed:

     

      result measure = SUMX(DISTINCT('Join'[Group]),[Sum Table 1 Pop Measure]*[Sum Probabilities Measure])

     

    I'll PM the dropbox link if you are curious.

     

    Thanks anyway!

Ruksuro's avatar
Ruksuro
Helper III
9 years ago

Hi Tom,

 

The act of producing a simplified model help the solution come to me! 

 

I simply needed:

 

  result measure = SUMX(DISTINCT('Join'[Group]),[Sum Table 1 Pop Measure]*[Sum Probabilities Measure])

 

I'll PM the dropbox link if you are curious.

 

Thanks anyway!

TomMartens's avatar
TomMartens
Super User
9 years ago

Perfect, I will have a look tomorrow, because I'm always curious :-)

 

Please mark your post with the DAX expression as answer, this may also help others.

 

Cheers