distinct sum

[Mniknejad]

I have two table one is a dim item like this 

ItemKEY	ItemNumber	ProductName	ColorDescription	Size	ORDERNUMBER	ID
46-07-2XL	46	ITEMA	Blue	2XL	8	87799
46-07-2XS	46	ITEMA	Blue	2XS	2	87775
46-07-3XL	46	ITEMA	Blue	3XL	9	87802
46-07-L	46	ITEMA	Blue	L	6	87791
46-07-M	46	ITEMA	Blue	M	5	87787
46-07-S	46	ITEMA	Blue	S	4	87783
46-07-XL	46	ITEMA	Blue	XL	7	87795
46-07-XS	46	ITEMA	Blue	XS	3	87779
46-11-2XL	46	ITEMA	Red	2XL	8	87671
46-11-2XS	46	ITEMA	Red	2XS	2	87646
46-11-3XL	46	ITEMA	Red	3XL	9	87675
46-11-L	46	ITEMA	Red	L	6	87663
46-11-M	46	ITEMA	Red	M	5	87659
46-11-S	46	ITEMA	Red	S	4	87654
46-11-XL	46	ITEMA	Red	XL	7	87667
46-11-XS	46	ITEMA	Red	XS	3	87650

another is fact like this 

ItemKey	color	ItemID	Size	InventoryDate	amount
46-11-2XS	11	46	2XS	2020-04-20	0
46-11-2XS	11	46	2XS	2020-04-21	0
46-11-S	11	46	S	2020-04-20	2
46-11-S	11	46	S	2020-04-21	1
46-11-2XS	11	46	2XS	2020-04-20	0
46-11-2XS	11	46	2XS	2020-04-21	0
46-11-3XL	11	46	3XL	2020-04-20	1
46-11-3XL	11	46	3XL	2020-04-21	1
46-07-S	7	46	S	2020-04-20	0
46-07-S	7	46	S	2020-04-21	3
46-11-3XL	11	46	3XL	2020-04-20	1
46-11-3XL	11	46	3XL	2020-04-21	1
46-11-XL	11	46	XL	2020-04-20	1
46-11-XL	11	46	XL	2020-04-21	1
46-11-M	11	46	M	2020-04-20	13
46-11-M	11	46	M	2020-04-21	1
46-7-XS	7	46	XS	2020-04-20	1
46-07-XS	7	46	XS	2020-04-21	1

these are joined on ItemKey and Itemkey is unique base on itemid,color and size but when I wanted to show  total Sum like this 

NAME	Total amount
ItemA	665

this is what I can get 

NAME	Total amount
ItemA	10
ItemA	235
ItemA	10
ItemA	10
ItemA	25
ItemA	5
ItemA	15
ItemA	90
ItemA	125
ItemA	25
ItemA	100
ItemA	5
ItemA	5
ItemA	5

Do you know what 's my issue ?

[harshnathani]

@Mniknejad ,

This is working fine with value as sum.

Regards,

Harsh Nathani

[harshnathani]

Hi @Mniknejad ,

Did the solution work for you.

Please mark as solution for other community members to benefit.

Regards,
Harsh Nathani
Did I answer your question? Mark my post as a solution! Appreciate with a Kudos!! (Click the Thumbs Up Button)

[nandukrishnavs]

@Mniknejad 

It seems like your default summarization is "Don't summarize". You have to choose Sum.

Please refer to this link https://docs.microsoft.com/en-us/power-bi/service-aggregates

Did I answer your question? Mark my post as a solution!
Appreciate with a kudos 🙂

[Mniknejad]

it's sum