Sum only one row per distinct Value in column

[motta]

Hello! 

I'm stuck with the following problem. I got different tool types used in the same run and I need to get the total used time for all 3 runs. Basically I need to dismiss the duplicated values for each run and add them up. Can some one help me with that?

Run ID	Used time	Tool Type
1	1.2	Tool 1
1	1.2	Tool 2
1	1.2	Tool 1
1	1.2	Tool 3
2	5.2	Tool 2
2	5.2	Tool 3
3	2.4	Tool 1
3	2.4	Tool 2
3	2.4	Tool 3
3	2.4	Tool 4
3	2.4	Tool 2

[Dangar332]

Hi, @motta 

try below code 

result = 
   calculate(
       sum('yourtable'[used time]),
       allexcept('yourtable','yourtable'[run id])
             )

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly. and don't forget to give kudos.

[motta · Accepted solution]

Not really, but thanks!

The below actually worked

Total Used hours = VAR distincttable =

SUMMARIZE ( 'Table', [RunID] , [Used Time] )

RETURN

SUMX ( distincttable, [Used Time] )