multiple conditional slicers

[Anonymous]

Hello everybody,

have the following simplified scenario,  I would like to be able to select columns (column 1 or column 2) first and then select operations (max or min). The Model and the Data looks as follows:

But as soon as I select column1 the operations slicer only shows one option the 'min', although min is not selected the min shows up...

how could it be realised that max does not disappear ... thx 

[SteveCampbell]

"SelectColumn" and "SelectValue" are in the same table, so they are filtering each other. Best practice, would to be to put them in two seperate tables.

You could add a cartesian join, but this may become more difficult to manage if you add more columns or values (such as average, sum etc).

[Anonymous]

@SteveCampbell after putting them in two separate tables. I cannot select the columns from a separate table. I get an error as shown in the picture.

[SteveCampbell]

SelectColumn[selection] refers to a column, so it finds it difficult to compare to one value.

Try replacing with:

SELECTEDVALUE( SelectColumn[selection] )

[Anonymous · Accepted solution]

@SteveCampbell  ok thanks for the hint

measure3 = IF(
SELECTEDVALUE(SelectColumn[selection]) = "column 1";
SWITCH(
    TRUE();
    VALUES(SelectOperation[condition 2]) = "min"; MINX(numbers; numbers[Column1]);
    VALUES(SelectOperation[condition 2]) = "max"; MAXX(numbers;numbers[Column1])
)
;IF(
        SELECTEDVALUE(SelectColumn[selection]) = "column 2";
        SWITCH(
            TRUE();
            VALUES(SelectOperation[condition 2]) = "min"; MINX(numbers; numbers[Column2]);
            VALUES(SelectOperation[condition 2]) = "max"; MAXX(numbers;numbers[Column2])
        )
        ))