Numeric slicer : show equal or greater values

[elois33]

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 numeric slicers are:  

LENGTH = GENERATESERIES(0,500)

WEIGHT= GENERATESERIES(0,500)

 

Once the users insert values to each slicer, I want only to show equal or greater values on the matrix table that follows. 

Until today I use this messure: 

For length values: 

CouponLEN = VAR MINValue= MIN('LENGTH'[Value]) VAR MAXValue= MAX('LENGTH'[Value]) VAR CurrentValue= [lenght_capacity] RETURN IF(CurrentValue >= MINValue && CurrentValue<=MAXValue, 1,0)

For weight values:

CouponWE = VAR MINValue= MIN('WEIGHT'[Value]) VAR MAXValue= MAX('WEIGHT'[Value]) VAR CurrentValue= [weight_capacity] RETURN IF(CurrentValue >= MINValue && CurrentValue<=MAXValue, 1,0)

And then in the filters section I choose to show COUPONLEN and COUPONWE =1

The problem is that it is not that accurate. Everytime I have inferior values that comes by on the table. For example: 

 

In this table I want to have the length and weight values by mission and by day. But these values I want them to be equal or greater to the numeric slicers on the top.

I think it takes into consideration the Length and Weight capacity of the week and not the day.

What do you think? 

Thank you for your help 🙂, 

[elois33]

@v-yalanwu-msft thank you for your help! Here is a sample of my file. https://drive.google.com/file/d/1NA8t4UOxLVZQil9HmEYT0GJRKBXuzl6-/view?usp=sharing

Thank you, Eloise

[v-yalanwu-msft]

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]

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