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

Creating an Reliability Level depending on some values

I want to measure the reliability that I station in a production line has
we evaluate 4 differente categories and those categories has some others sub categories 

what I want to achieve is this 
If the number of events (sum) is < 50 reliability = High
If number of events >= 50 and <75 reliability = Regular

If number of events >=75 and <99 reliability = Medium
If number of events >= 99 and <140 reliability = Bad
If number of events >140 reliability = Non-Reliable

I use this formula but it shows all as "High Reliability" which is incorrect due that some stations have more than 140 events 

Reliability = IF(
Actuadores[Eventos] <50,"High",
IF(AND(Actuadores[Events] >= 50,Actuadores[Events] <75),"Regular",
IF(AND(Actuadores[Events] >= 75, Actuadores[Events] <99),"Medium",
IF(AND(Actuadores[Events] >= 99, Actuadores[Events] <140),"Bad",
IF(Actuadores[Eventos] >140,"Non Reliable")))))


I have to remark that this formula is going to be filtered to a specific station and on the last 2 days of records 
not all of them just Today's and Yesterday's values 



1 ACCEPTED SOLUTION
Super User IV
Super User IV

@EC3 , if this a measure (Events) and you are creating a column this will not work. The measure can not be used.

To create a bucket on measure you need an independent table and use that to create a new measure that can use this independent table.

 

Refer if my video can help https://www.youtube.com/watch?v=CuczXPj0N-k

 

or

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!

View solution in original post

3 REPLIES 3
Super User III
Super User III

Hi,

Since you want the result to respond to change in slicer selections, you must follow the procedure of dynamic segmentation discussed here - https://www.daxpatterns.com/dynamic-segmentation/.

Hope this helps.


Regards,
Ashish Mathur
http://www.ashishmathur.com
https://www.linkedin.com/in/excelenthusiasts/

Your video was really helpful 

Super User IV
Super User IV

@EC3 , if this a measure (Events) and you are creating a column this will not work. The measure can not be used.

To create a bucket on measure you need an independent table and use that to create a new measure that can use this independent table.

 

Refer if my video can help https://www.youtube.com/watch?v=CuczXPj0N-k

 

or

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!

View solution in original post

Helpful resources

Announcements
secondImage

Happy New Year from Power BI

This is a must watch for a message from Power BI!

December Update

Check it Out!

Click here to read more about the December 2020 Updates!

Community Blog

Check it Out!

Click here to read the latest blog and learn more about contributing to the Power BI blog!

Get Ready for Power BI Dev Camp

Get Ready for Power BI Dev Camp

Mark your calendars and join us for our next Power BI Dev Camp!.

Top Solution Authors
Top Kudoed Authors