Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
Ruksuro
Helper III
Helper III

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 which does the equivalent of SUMPRODUCT, taking each line in Table 1 and mutliplying by the related value in Table 2. Table 2 will be filtered on the dashboard to resolve the many-many issue.

 

There are over 50 "types" in each table so it must remain a many-many structure (I don't want 50x tables floating about).

 

Any help appreciated, thanks!

 

Harry.

1 ACCEPTED SOLUTION

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!

View solution in original post

4 REPLIES 4
TomMartens
Super User
Super User

Hey,

 

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

 

Regards 



Did I answer your question? Mark my post as a solution, this will help others!

Proud to be a Super User!
I accept Kudos 😉
Hamburg, Germany

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!

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



Did I answer your question? Mark my post as a solution, this will help others!

Proud to be a Super User!
I accept Kudos 😉
Hamburg, Germany

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 🙂

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.