How to sum up one column, but exclude values when values of another column are doubled?

[Womkas_90]

Hello Again dear Community,

Im just not getting the hang of it 😞

I want to sum up all involved Persons, but take only 1 in consideration per ID_Product.

Therefore i want to get the sum of 1+4+2+5+3  = 15

I thought i could use

= CALCULATE(SUMX('TABLE',[Involved_Persons]), DISTINCT('TABLE'[ID_Product]))

I understand, that now the distinction is made in every row, therefore it returns it this way, because the date is unique.

ID_Category	ID_Product	Date	Involved_Persons
1	1	01.02.2020	1
1	1	01.03.2020	1
1	2	01.04.2020	4
1	3	01.05.2020	2
1	4	01.06.2020	5
1	4	01.07.2020	5
1	4	01.08.2020	5
1	4	01.09.2020	5
2	6	01.11.2020	3
2	6	01.12.2020	3
2	6	01.01.2021	3

Can someone help me with that? Thank you very much!

[v-yinliw-msft · Accepted solution]

Hi @Womkas_90 ,

You can try the following methods.

Measure:

Total =

SUMX(

    SUMMARIZE(

        'PRODUCT','PRODUCT'[ID_Product],'PRODUCT'[Involved_Persons]

        ),

        [Involved_Persons]

    )

Is this the result you expect?

Best Regards,

Community Support Team _Yinliw

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[amitchandak]

@Womkas_90 , You need use calculate here

SUMX(values('TABLE'[Involved_Persons]),calculate( DISTINCT('TABLE'[ID_Product])))

or countrows(Sumamrize(Table, Table[Involved_Persons],'TABLE'[ID_Product]))