Reply
Cednok
Frequent Visitor
Partially syndicated - Outbound

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

Cednok_0-1623665341282.png

 

 


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

 

1 ACCEPTED SOLUTION
amitchandak
Super User
Super User

Syndicated - Outbound

@Cednok , Create a meausre like

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

Full Power BI Video 20 Hours YouTube
Microsoft Fabric Series 60+ Videos YouTube
Microsoft Fabric Hindi End to End YouTube

View solution in original post

2 REPLIES 2
amitchandak
Super User
Super User

Syndicated - Outbound

@Cednok , Create a meausre like

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

Full Power BI Video 20 Hours YouTube
Microsoft Fabric Series 60+ Videos YouTube
Microsoft Fabric Hindi End to End YouTube

Syndicated - Outbound

Perfect Thank you very much

avatar user

Helpful resources

Announcements
March PBI video - carousel

Power BI Monthly Update - March 2025

Check out the March 2025 Power BI update to learn about new features.

March2025 Carousel

Fabric Community Update - March 2025

Find out what's new and trending in the Fabric community.

Top Solution Authors (Last Month)
Top Kudoed Authors (Last Month)