topic Re: Sum values of a join relation in DAX Commands and Tips

Sum values of a join relation

mizaskun — Tue, 11 May 2021 10:05:33 GMT

Good morning,

I have the following tables:

and

I have related the tables through the Car field.

I am trying to get the sum of every resulting line from the join, but I am getting just the sum of the cars table.

The measure gives 3 as a result, but should give 5. And it is calculated like this:

Medida = SUMX(Cars, Cars[Value])

How should I achieve this?

Thank you so much!

Jihwan_Kim — Tue, 11 May 2021 10:19:22 GMT

Please try the below.

The link to the sample pbix file is down below.

Values Total =

SUMX( Regions, RELATED(Cars[Value]))

Hi, My name is Jihwan Kim.

If this post helps, then please consider accept it as the solution to help other members find it faster, and give a big thumbs up.

Linkedin: linkedin.com/in/jihwankim1975/

Twitter: twitter.com/Jihwan_JHKIM

mizaskun — Thu, 13 May 2021 15:19:37 GMT

Good afternoon,

This is not working on a many to many relation. How should I achieve that average with a many to many relationship?

Thank you so much!

Jihwan_Kim — Thu, 13 May 2021 17:03:53 GMT

thank you for your feedback.

Sorry that I am not familiar with how many to many relationship works.

mizaskun — Fri, 14 May 2021 06:44:38 GMT

Thank you so much anyway!