Sum Distinct value for same markets

[Anonymous]

Hi Team,

I have data like below Tbl 1 and values are repeated but i need to sum distinct value only see Tbl 2.

Tbl 1 :

Tbl 2 :

Thanks,

KV's

[amitchandak · Accepted solution]

@Anonymous , Create a measure like

sumx(summarize(Table, Table[market], table[ID], Table[value]), [Value])