Forum Discussion
Need Urgent help
- 2 years ago
Hi Anonymous
please refer to the linked video:
https://www.youtube.com/watch?v=FDa0I3J3h-cIf this post helps, then please consider Accepting it as the solution to help the other members find it more quickly
- 2 years ago
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! 🤠
Sorry for the inconvenience. I have updated the link and given access to all. You can check it
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! 🤠