Number Slicer

Schifo78 — Wed, 05 Apr 2023 12:05:53 GMT

Hi I have a table set up as follows (example numbers):

Supplier	Min	Max
Supplier A	0	5000
Supplier B	100	500
Supplier C	0	2000
Supplier D	1000	10000
Supplier E	0	6000

The Min value has a relationship to a generateseries table of numbers incremented by 1. I am using that value in the slicer two sided slicer.

I'm trying to create a measure that I can use the slicer to filter out suppliers if the minimum order level they supply is higher than the selected value (so the minimum order is above what I want) and the maximum level they can supply is less than the selected value (so they can't do the volume required).

So for example if I wanted a supplier without a minimum order threshold e.g. 0 but could satisfy orders up to 5500 then the measure would only return a true against Supplier E. If I then decided to remove the lower bound then the filter would bring back Supplier D and E etc.

I've tried various configuration for the dax measure for this but can't acheive the result I need, anyone have any ideas?

Thanks

Re: Number Slicer

FreemanZ — Wed, 05 Apr 2023 13:50:44 GMT

hi Schifo78

not sure if i fully get you.

supposing you have two tables like:

they are not related with any table.

try to plot slicers and a table visual with necessary columns and a measure like:

Measure = IF( MAX(TableName[MIN])<=MAX(MinSlicer[Value]) &&MAX(TableName[MAX])>=MIN(MaxSlicer[Value]), TRUE, FALSE )

it worked like:

topic Re: Number Slicer in DAX Commands and Tips

Number Slicer

Re: Number Slicer