Forum Discussion

Cednok's avatar
Cednok
Frequent Visitor
5 years ago
Solved

Lost time calcul with more value

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

 

  • Cednok , Create a meausre like

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

2 Replies

  • Cednok , Create a meausre like

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

    • Cednok's avatar
      Cednok
      Frequent Visitor

      Perfect Thank you very much