Sum only once per distinct id

[marijane]

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 function with sumx should be avoided because my original table has much more than one million rows and I think will be very slow with this approach.

Can you help?
Thank you very much for your time.

id	hours
1	27
2	30
2	30
3	30
3	30
3	30
3	30
4	2

[amitchandak · Accepted solution]

@marijane , summarize or values are the options you can use

Try values with sumx

sumx(Values(Table[ID]), calculate(max(Table[Hour])))

[ilanapregen]

i love you.