Numeric range dropdown filter

This is a example of the card measure:

Hi ValtteriN 

Below you can see the calculated columns and measures that i use as cards and matrixes. The graph works perfectly with the parameter but the matrix doesnt show any data and the card and can't set the Rooms Filter to = 1. 

Graph(works)
The graph works fine. I have a date column as axis, a calculated column as Legend and a measure in Values:
-Legend: 

Calculated Column=

if(Table1[columnX] = "Legend1", "Legend2",

if(Table1[columnX] <> "Legend1" || Table1[columnX] = "Legend1","All"))
-Values:

Measure =

CALCULATE(AVERAGE(Table1[columnY]),Table1[columnZ] = "B")

I also have a date filter on the filters pane saying only look at data from today and 3 months back.

 

Card(doesnt work)

Measure =

CALCULATE(COUNT(Table1[ColumnY]),Table1[ColumnZ] = "B")

I also have a date filter on the filters pane saying only look at data from today and 3 months back.

 

Matrix(doesnt work)

-Rows
Calculated Column =
if(Table1[ColumnX] = "example text", "output",
if(Table1[ColumnX] <> "example text"|| Table1[ColumnX] = "example text", "output2"))

-Columns
Calculated Column =
if(Table1[Datesegment] = "1", " X",
if(Table1[Datesegment] = "2", " Y",
if(Table1[Datesegment] = "3", " Z",
if(Table1[Datesegment] = "4", "F"))))
-Values
Measure =
CALCULATE(AVERAGE(Table1[price]),Table1[category] = "V")

 

 

 

 

 

 

 

 

 

arvin 

Card:

Normally you can't filter card with a measure. To circumvent this we can first create a table visual and place the filter there:

Now convert it to a card:

As for the matrix:

Instead of nested IFs you should use
SWITCH(TRUE(),
condition1,result1,
condition2,resul2) structure.

This doesn't solve the issue but it is more readable.

My assumption is that your columns work and the issue is with the measure. You can you test this b testing the visual with this: 

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

If this return values this should work:

Working Measure =
var cc1 = Max(Calculated Column)
var cc2 = Max(Calculated Column2) return

CALCULATE(AVERAGE(Table1[price]),Table1[category] = "V",ALL(Table1),
Table1[Calculated Column]=cc1,Table1[Calculated Column]=cc2)

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

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?

Hi ValtteriN 

The matrix now shows correct values with the "working measure" in the values section.
The problem is still that it does not respond accurate to the parameters, when choosing for example from = 2 and to = 4, the data in the matrix disappears.