Why is the relation lost when I try to sum across tables?

[spr410]

An example

I have two tables:  

Series	Item			item	qty
AA	a1			a1	100
AA	a2			a2	200
BB	b1			b1	300
BB	b2			b2	400
BB	b3			b3	500
CC	c1			c1	100
CC	c2			c2	200
CC	c3			c3	300
CC	c4			c4	400

I want to use relations to sum qty for each series, I want to have a result like this:

Series	qty
AA	300
BB	1200
CC	1000

instead i got 

Series	qty
AA	2500
BB	2500
CC	2500

Why is the relation not working ?

Thanks

[Vallirajap · Accepted solution]

Hi @spr410 ,

when I try this above use case it shows the correct value.

There is no relationship lost or nothing is happen in the PBI report 

Did I answer your question?

Mark my post as a solution, this will help others...!

Hit the kudo also,

Thank you

[Daniel29195 · Accepted solution]

Hello @spr410 

 it seems like you have a problem in the modeling part. 

can you please make sure that you have a relation in the model view between 

item from table 1 to item from table 2 . 

and that the relation is 1 to many . 

[Vallirajap · Accepted solution]

Hi @spr410 ,

when I try this above use case it shows the correct value.

There is no relationship lost or nothing is happen in the PBI report 

Did I answer your question?

Mark my post as a solution, this will help others...!

Hit the kudo also,

Thank you