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

It works on tables and graphs, but when i have no option selected in the parameters the data disapears, can i create the measure so that when nothing is selected, all data is showing?

It does not work on matrixes and cards, in the picture below i can't select the Rooms Filter = 1.

 

 

  • ValtteriN's avatar
    ValtteriN
    Community Champion
    4 years ago

    Here is modified filter which works also when nothing is selected:

    RoomsFilter =
    var _rooms = max(RoomsToFrom[Rooms])
    var _roomsfrom = IF([RoomsFrom Value]=BLANK(),0,[RoomsFrom Value])
    var _roomsto = IF([RoomsTo Value]=BLANK(),999,[RoomsTo Value])
    return

    IF(and(_rooms<=_roomsto,_rooms>=_roomsfrom) ,1,0)