Measure reliability based on number fo events

[Anonymous]

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?

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

[amitchandak]

@Anonymous , 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

[Anonymous]

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

[v-jayw-msft · Accepted solution]

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