Skip to main content
cancel
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

Reply
elois33
Helper I
Helper I

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

 

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

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: 

 

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 🙂

3 REPLIES 3
elois33
Helper I
Helper I

@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
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:

vyalanwumsft_0-1669097951332.png

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

Announcements
Europe Fabric Conference

Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

AugPowerBI_Carousel

Power BI Monthly Update - August 2024

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

August Carousel

Fabric Community Update - August 2024

Find out what's new and trending in the Fabric Community.