Forum Discussion
marijane
Helper I
Helper ISum only once per distinct id
Hi everyone, I want to sum hours only once per id using dax. For example, in this table above the expected result of the measure will be 89 : 27(id1) + 30(id2) +30(id3) + 2(id4) The summarize f...
marijane , summarize or values are the options you can use
Try values with sumx
sumx(Values(Table[ID]), calculate(max(Table[Hour])))
amitchandak
Super User
Super Usermarijane , summarize or values are the options you can use
Try values with sumx
sumx(Values(Table[ID]), calculate(max(Table[Hour])))
i love you.