Sum of values based on distinct values in other column

[saracaballero]

Hello,

I have a table with two columns, amount_total, and so_ref:

As you can see from the table, I have repeated so_ref. Thus, I would want to sum the amount_total when the so_ref is distinct. 

Could you help me, please?

Thank you very much,

Sara

[Ani1991]

Hi @saracaballero ,

You can try the below code.

DISTSUM = SUMX(DISTINCT(SO[SO Number]),CALCULATE(AVERAGE(SO[Total ref])))

Hope this helps!!

Regards,

Ani

[AlB · Accepted solution]

Hi @saracaballero 

Do you mean you want to sum across amount_total but adding the ones for which so_ref is repeated only once? If so, create a measure and place it in a card visual:

Measure = SUMX( DISTINCT(Table1[so_ref]),
                CALCULATE(DISTINCT(Table1[amount_total]))
               )

Please mark the question solved when we get to the solution and consider kudoing if posts are helpful.

Cheers