topic How to sum up one column, but exclude values when values of another column are doubled? in DAX Commands and Tips

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

Womkas_90 — Thu, 08 Sep 2022 07:35:50 GMT

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.

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

amitchandak — Thu, 08 Sep 2022 08:11:26 GMT

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]))

v-yinliw-msft — Fri, 09 Sep 2022 02:55:18 GMT

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.