Forum Discussion
Cednok
5 years agoFrequent Visitor
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
- amitchandak
Super User
Cednok , Create a meausre like
sumx(summarize(Table, Table[Ref Article], Table[Article], Table[Lost Time]),[Lost time])
- CednokFrequent Visitor
Perfect Thank you very much