Lost time calcul with more value

[Cednok]

Hi the community,

I need to calculate the time lost on anomalies to be corrected

Here is my table

The problem is that if there are several anomalies on the same account item for a on the example the time lost is: 60+50+30+70 because on the 6 anomalies 2 counts for 1 are present 2 times

Can you tell me how to do the measurement please?

Thank you in advance

[amitchandak · Accepted solution]

@Cednok , Create a meausre like

sumx(summarize(Table, Table[Ref Article], Table[Article], Table[Lost Time]),[Lost time])

[Cednok]

Perfect Thank you very much