Sum distinct of values

[Anonymous]

Hello, I have the table below and I'm trying to construct a DAX formula to do the following calculation, but haven't succeeded.

Kilometers Value = SumX("Km end of day") , Filter(disticnt (object )) &&  Filter Ditinct (Date)

Date	Object	Km end of day
1-1-2020	12	815
1-1-2020	15	741
1-1-2020	12	815
1-1-2020	12	815
1-1-2020	11	828
1-1-2020	15	741
2-1-2020	12	695
2-1-2020	15	850
2-1-2020	12	695
2-1-2020	11	760
2-1-2020	15	850

Desireble result:

Kilometers Value 

Object	Km value
15	1519
12	2205
11	4569

 I have found several references to Distinct count calculations, but none seems to give me the result that I require. Any suggestions much appreciated!

Many thanks,

Ezz

[amitchandak]

@Anonymous , try

Km value = sumx(summarize(Table, table[object],table[Km end of day]),[Km end of day])