Forum Discussion

Schifo78's avatar
Schifo78
Frequent Visitor
3 years ago

Number Slicer

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

 

SupplierMinMax
Supplier A05000
Supplier B100500
Supplier C02000
Supplier D100010000
Supplier E06000

 

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

DAX

1 Reply

  • FreemanZ's avatar
    FreemanZ
    Icon for Super User rankSuper User
    3 years ago

    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: