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!

TomMartens's avatar
TomMartens
Super User
9 years ago

Hey,

 

can you please provide a sample pbix file and share the link to the file on onedrive or dropbox.

 

Regards 

  • 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

  • Ruksuro's avatar
    Ruksuro
    Helper III
    9 years ago

    Hi Tom,

     

    Will do! But I'll have to do it tonight from my home pc for corporate security reasons.

     

    Watch this space!

     

    Thanks again :)