Forum Discussion

esquiveljc's avatar
esquiveljc
Helper I
1 year ago
Solved

Filter another filter with parameters

Hi everyone,

 

I have a table with 4 cities with assigned numbers for each column: D, E, and F.  I also have another column with the maximum values ​​in D, E, and F for each city.

 

City       MaxDEF D     E         F

Miami1011
Boston2210
Chicago3321
Seattle3003

 

These numbers represent colors.

 

I put this in a map, and for the legend I created the following parameter:

 

Parameter = {
("MaxDEF", NAMEOF('Table'[MaxDEF]), 0),
("D", NAMEOF('Table'[D]), 1),
("E", NAMEOF('Table'[E]), 2),
("F", NAMEOF('Table'[F]), 3)
}

 

I put too these parameter in my FilterLevel1.

 

This works fine, but I want a second filter (FilterLevel2) to be able to choose the color numbers for each choice in my FilterLevel1. So to explain better, in my FilterLevel1 when I choose the MaxDEF option, my FilterLevel2 should display "1, 2, 3". When I select "D" in my FilterLevel1, it should display "0,2,3" in my FilterLevel2, and so on.

 

Do you have any idea how I can create FilterLevel2 knowing that a filter doesn't accept measure?

 

Thank you!

1 Reply