Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

SUM where DISTINCT ID

I have a table where there a multiple rows of the same project, but for different years, and one specific value that's constant between all the years, I would like to summarize this value, but only o...
Need Help
Tutorial Requests
  • amitchandak's avatar
    amitchandak
    5 years ago

    Anonymous , Based on what I got, Try a new measure

    sumx(summarize(Table, Table[project], Table[value]),[Value])

amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
5 years ago

Anonymous , Based on what I got, Try a new measure

sumx(summarize(Table, Table[project], Table[value]),[Value])

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    amitchandak , Thanks! This worked perfectly. Learned something new today 😃 Cheers