Forum Discussion

arvin's avatar
arvin
Regular Visitor
4 years ago

Numeric range dropdown filter

Hi I have an excel dataset as underlying data. It is housing data, so for each row i have a column saying how many rooms the apartment have. See the image below for the column and values. ...
DAX
Filters
slicers
arvin's avatar
arvin
Regular Visitor
4 years ago

Hi, I did ecatly what you said and tried to apply the measure in my matrix, but it doesnt seem to work, it worked on tables, but i have multiple matrixes like the image below and nothing happens:

 

ValtteriN's avatar
ValtteriN
Community Champion
4 years ago

Hi,

It is important the filter is "Rooms filter is 1" Now you have "Rooms filter is 1 or 0" This defeats the purpose and it is likely the reason the filter is not working.

  • arvin's avatar
    arvin
    Regular Visitor
    4 years ago

    Sorry i sent the wrong printscreen. Here is the correct one. I have the measure = 1 and nothing shows.

     

    • ValtteriN's avatar
      ValtteriN
      Community Champion
      4 years ago

      Hmm, 

      That is curious behaviour. Could you show the DAX you used?

       

      • arvin's avatar
        arvin
        Regular Visitor
        4 years ago
        I created two parameters; Från(from) and Till(to)
         
        The measure is below:
        -Blad1[antal rum] is the column with rooms in my dataset.
        RoomsFilter =
        var _rooms = max(Blad1[antal rum])
        return
        IF(and(_rooms<=[Till Value],_rooms>=[Från Value]) ,1,0)

        I do have a measure in the matrix Values section, i dont know if that creates a problem.