Forum Discussion

elois33's avatar
elois33
Icon for Helper I rankHelper I
3 years ago

Numeric slicer : show equal or greater values

Hello,    I have one more issue with my dashbord and more specificaly with the numeric slicer. I have 2 numeric slicer, one for weight and the other for lenght as pictured bellow   These nu...
Need Help
v-yalanwu-msft's avatar
v-yalanwu-msft
Icon for Community Support rankCommunity Support
3 years ago

Hi , elois33 ;

You could try create a measure rather than filter this measure.

CouponLEN = 
VAR MINValue= MIN('LENGTH'[Value]) 
VAR MAXValue= MAX('LENGTH'[Value]) 
VAR CurrentValue=SUM('Table'[lenght] )
RETURN CALCULATE(SUM('Table'[lenght]),FILTER('Table',[lenght]<=MAX('LENGTH'[Value])&&[lenght]>=MIN('LENGTH'[Value])))

 the final show:

If the above one can't help you get the desired result, Can you share a simple file to remove sensitive information? I can't reproduce your data and tests.
Best Regards,
Community Support Team _ Yalan Wu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

elois33's avatar
elois33
Icon for Helper I rankHelper I
3 years ago

thank you for the solution provided and I m very sory the the delayed answer. Well my "lenght" and "weight" capacity is already a measure calculated from 2 columns (total capacity minus used capacity) so a measure which includes another measure on it, it doesnt work for that. 😕 Do you know maybe another way?  thanks