cancel
Showing results for
Did you mean:
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?

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

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.
3 REPLIES 3
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

Proud to be a Super User!

Helper I
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

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.

Announcements

#### Power Platform Community Conference

Check out the on demand sessions that are available now!

#### Power Platform October Community Highlights

Check out the top community contributors across all of the communities

#### 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