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 ValtteriN 

I tried the card trick and it did not work when choosing a parameter, the value is the same every time.

 

I also tried the test measure for the matrix, but all values in the matrix became identical and when choosing parameters they all disappeared, picture below:

 

TestMeasure =

CALCULATE(AVERAGE(Table1[price]),Table1[category] = "V",ALL(Table1))

 

 

 

 

 

 

ValtteriN's avatar
ValtteriN
Community Champion
4 years ago

Hi,
arvin 
The test measure did it job if you got some values into the matrix. Now we just need to figure out how to get the filter context to function based on this test. What values did the "working measrure" return?