help: counting number of values below and above the selected range

[lawada]

i have a table that shows the following values:

laundry name- total orders- placed orders -successful orders- success rate[overall] %,success rate %

where the success rate[overall] is a measure calculated by : [Successful Orders]/[Total Orders]
and the success rate is a measure too that is calculated by:[Successful Orders]/[Placed Orders]

i have created  a percentage selector slicer where i can select the percentage range and  slice the table by the success rate[overall] (the  % selector was created using a seperate table with the "generateseries" function.

Now, i have to create 2 measures,  the 1st will count number of laundries below the selected range and the 2nd measure will count number of laundries above the selected range.

note:1- overall orders,successful orders,placed orders are also a measuers created by counting the "orderID" from orders table where each of the three has a different status.

2- this table is filtered by "country name" from countries table, "order date" from orders table,"laundry name" from laundries table.

laundry name	total orders	placed orders	succussful orders	success rate[overall] %	success rate %
laundry 1	203	185	162	80%	87.57%
laundry 2	201	180	161	80%	89.44%
laundry 3	185	164	140	76%	85.37%
laundry 4	172	161	150	87%	93.17%
laundry 5	205	183	148	72%	80.87%
laundry 6	211	193	174	82%	90.16%

[amitchandak]

@lawada , Not very Clear

seem like every similar to segmentation,

refer if thwse can help

https://www.daxpatterns.com/dynamic-segmentation/
https://www.daxpatterns.com/static-segmentation/
https://www.poweredsolutions.co/2020/01/11/dax-vs-power-query-static-segmentation-in-power-bi-dax-po...
https://radacad.com/grouping-and-binning-step-towards-better-data-visualization

https://radacad.com/dynamic-banding-or-grouping-in-power-bi-using-dax-measures-choose-the-size-of-bi...
https://www.credera.com/blog/technology-solutions/creating-aging-report-using-a-user-selected-date-i...

[Greg_Deckler]

@lawada This looks like a measure aggregation problem. See my blog article about that here: https://community.powerbi.com/t5/Community-Blog/Design-Pattern-Groups-and-Super-Groups/ba-p/138149

The pattern is:
MinScoreMeasure = MINX ( SUMMARIZE ( Table, Table[Group] , "Measure",[YourMeasure] ), [Measure])
MaxScoreMeasure = MAXX ( SUMMARIZE ( Table, Table[Group] , "Measure",[YourMeasure] ), [Measure])
AvgScoreMeasure = AVERAGEX ( SUMMARIZE ( Table, Table[Group] , "Measure",[YourMeasure] ), [Measure])
etc.