Qlik Sense Sum of measure where dimension is Distinct

[valantis21]

Hello guys, a quick question.

I am searching a way to sum up the below Measure where:

code is distinct AND H Level = CDI AND TIME = mtd.

code	H Level	Team	RM	TIME	product	Measure
a	CDI	A	A	mtd	1	10
a	CDI	A	B	mtd	2	10
a	CDI	A	C	ytd	3	10
b	CDI	A	A	mtd	1	10
b	ACCOUNT	A	B	mtd	2	10
b	CDI	A	C	ytd	3	10

So expected to get a result:

cdi	pfa
a	10
b	10

I have found that aggr - sum function with distinct creates a temporary table with unique values but I could find a way to combine aggr - sum with set analysis for H level and TIME .

Thanks in advance

[vinieme12]

sum({<TIME={'mtd'},[H Level]={'CDI'}>}distinct Measure)

[Valantis]

This does not result in Distinct Codes , we need aggr sum for this but i cannot find a way to use aggr sum with above set analysis f.e

[Valantis]

F.E if you have 2 codes with same measure as above is will result in keeping only one code (f.e a code)