Need Urgent help

Hi Anonymous 
please refer to the linked video:
https://www.youtube.com/watch?v=FDa0I3J3h-c

If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly

Anonymous 

if this is what you want : 

then just modify the code to this : 

Measure 9 = 
var lowerbound = MIN(Segment_table[Min])
var upperbound =  MAX(Segment_table[max])

var ds = 
FILTER(
   
        VALUES(Sheet1[UUID]),
  
    [Total Revenue] >= lowerbound && [Total Revenue]< upperbound
)


return COUNTROWS(ds)

let me know if this works. 

If my answer helped sort things out for you, i would appreciate a thumbs up 👍 and mark it as the solution ✅
It makes a difference and might help someone else too. Thanks for spreading the good vibes! 🤠