Skip to main content
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Helper I
Helper I

Numeric slicer : show equal or greater values



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


Capture d’écran 2022-11-21 093005.png

These numeric slicers are:  


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: 


Capture d’écran 2022-11-21 095250.png

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 🙂

Helper I
Helper I

@v-yalanwu-msft thank you for your help! Here is a sample of my file.


Thank you, Eloise

Community Support
Community Support

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.

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

Helpful resources

July 2024 Power BI Update

Power BI Monthly Update - July 2024

Check out the July 2024 Power BI update to learn about new features.


Fabric Community Update - June 2024

Get the latest Fabric updates from Build 2024, key Skills Challenge voucher deadlines, top blogs, forum posts, and product ideas.

Top Solution Authors