Help with relativelly "simple" mesure that ignore repeated values

[erfaldo]

Hello, 

I have spend the hole weeked trying to create a DAX mesure without success, I ask for help to the community

In the following Table I need to calculate the total of Elements "based" on column "Quantity", but I need to consider only 1 value when Detail of Element are multiple (In that case Quantity is always the same).

Element	Detail	Quantity	DATE	Nom
a	1	10	10-oct	AAA
a	2	10	10-oct	AAA
a	3	10	10-oct	AAA
b	1	12	15-nov	AAA
b	2	12	15-nov	AAA
c	1	15	15-nov	AAA
c	2	15	15-nov	AAA
c	3	15	15-nov	AAA
c	4	15	15-nov	AAA
d	2	5	09-oct	BBB
e	3	2	08-oct	BBB
f	5	1	11-nov	CCC

Expected result is as follow:

		Number of Quantity
a		10
b		12
c		15
d		5
e		2
f		1

And the mesure need to be able to be calculated also at Date and Name level

DATE		Calculated Quantity
October		17
November		28

Name		Calculated Quantity
AAA		37
BBB		7
CCC		1

I get confused with the Filter level to apply 

Any help will be very appreciated

[VahidDM · Accepted solution]

Hi @erfaldo 

Try this measure and use that in those scenarios:

Calculated Quantity = 
Var _A = SUMMARIZE('Table','Table'[Element],'Table'[Quantity],'Table'[DATE],'Table'[Nom])
return
sumx(_A,[Quantity])

If this post helps, please consider accepting it as the solution to help the other members find it more quickly.
Appreciate your Kudos!!
LinkedIn: www.linkedin.com/in/vahid-dm/

[erfaldo]

Incredible simple...I was getting confused trying with filters...

Thank you for your Help!!!