Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Sum Distinct value for same markets

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
Need Help
  • amitchandak's avatar
    amitchandak
    5 years ago

    Anonymous , Create a measure like

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

amitchandak's avatar
amitchandak
Super User
5 years ago

Anonymous , Create a measure like

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