I want to measure the reliability that I station in a production line haswe 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 = HighIf number of events >= 50 and <75 reliability = Regular
If number of events >=75 and <99 reliability = MediumIf number of events >= 99 and <140 reliability = BadIf number of events >140 reliability = Non-ReliableI 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
Go to Solution.
@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
Proud to be a Super User!
View solution in original post
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.
Your video was really helpful
Check out the on demand sessions that are available now!
Check out the Winners!
Learn how Power BI works with the latest Azure data and analytics innovations at the digital event with Microsoft CEO Satya Nadella.