cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Helper I
Helper I

Measure reliability based on number fo events

I have a table that show failure in a line production
I need to create a formular to measure reliability based on the number of events of a specific station

like this
If number of events <50 High reliability
If number of events >=50 and <75 Regular reliability
If number of events >=75 and <99 Medimm Reliability 
If number of events >= 99 and <140 Bad Reliability and lastly
If number of events <140 Non-reliable 

This number of events are filtered by a specific station "DJM370" 

Is this posible?

EC3_0-1602684395191.png

and if a change the date filtered to current month, last week or last 3 months does th reliable value gonna change?

1 ACCEPTED SOLUTION

Accepted Solutions
Community Support
Community Support

Hello @EC3 ,

Try the SWITCH() function.

Reliability =
SWITCH (
    TRUE (),
    Actuators[Events] < 50, "High Efficiency",
    Actuators[Events] >= 50
        && Actuators[Events] < 75, "Regular Efficiency",
    Actuators[Events] >= 75
        && Actuators[Events] < 99, "Medium Efficiency",
    Actuators[Events] >= 99
        && Actuators[Events] < 140, "Low Efficiency",
    Actuators[Events] >= 140, "Very Low Efficiency"
)

Best regards

Jay

Community Support Team _ Jay
If this post helps, then please consider Accept it as the solution to help the other members find it.

View solution in original post

3 REPLIES 3
Super User IV
Super User IV

@EC3 , seem like you need dynamic segmentation, See if my video can help: https://www.youtube.com/watch?v=CuczXPj0N-k

 

You need to have  an independent table and then use this new table to bin the measure and create anew measure where you can use this bucket

 

or refer: https://www.daxpatterns.com/dynamic-segmentation/
https://radacad.com/grouping-and-binning-step-towards-better-data-visualization

 

 



Did I answer your question? Mark my post as a solution! Appreciate your Kudos!!
Dashboard of My Blogs !! YouTube Channel !! Connect on Linkedin

Proud to be a Super User!

Im using this formula that

Reliability - IF(
Actuators[Events] <50,"High Efficiency",
IF(AND(Actuators[Events] > 50,Actuators[Events] <75),"Regular Efficiency",
IF(AND(Actuators[Events] > TM 75, Actuators[Events] <99),"Medium Efficiency",
IF(AND(Actuators[Events] > TM 99, Actuators[Events] <140),"Low Efficiency",
IF(Actuators[Events] >140,"Very Low Efficiency")))))

But the result isn't correct

Captura.PNG



Community Support
Community Support

Hello @EC3 ,

Try the SWITCH() function.

Reliability =
SWITCH (
    TRUE (),
    Actuators[Events] < 50, "High Efficiency",
    Actuators[Events] >= 50
        && Actuators[Events] < 75, "Regular Efficiency",
    Actuators[Events] >= 75
        && Actuators[Events] < 99, "Medium Efficiency",
    Actuators[Events] >= 99
        && Actuators[Events] < 140, "Low Efficiency",
    Actuators[Events] >= 140, "Very Low Efficiency"
)

Best regards

Jay

Community Support Team _ Jay
If this post helps, then please consider Accept it as the solution to help the other members find it.

View solution in original post

Helpful resources

Announcements
November Update

Check it Out!

Click here to read more about the November 2020 Updates!

Community Conference

Power Platform Community Conference

Check out the on demand sessions that are available now!

secondImage

Power Platform October Community Highlights

Check out the top community contributors across all of the communities

secondImage

Create an end-to-end data and analytics solution

Learn how Power BI works with the latest Azure data and analytics innovations at the digital event with Microsoft CEO Satya Nadella.

Top Solution Authors
Top Kudoed Authors