Forum Discussion
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...
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!
Hey,
can you please provide a sample pbix file and share the link to the file on onedrive or dropbox.
Regards
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 :)