Switch filter not works well in Power BI

[Analitika]

Hello,

I would like to make that if user select filter box it getting different values. Filter 

I am having three different cases:

If I select Be kasos I should get value 

measure[USED Pardavimai be kasu],

if selected Su kasa then 

[USED OK Pardavimai]

If selects both 

[USED OK Pardavimai].

But I am having issue that Be kasos case not working.

Sales Amount =

SWITCH (

TRUE (),

MAX('Pajamu vaizdavimas'[Parinkimas 4]) IN { "Be kasos", "Su kasa"}, [USED OK Pardavimai],

MAX('Pajamu vaizdavimas'[Parinkimas 4]) = "Be kasos", [USED Pardavimai be kasu],

MAX('Pajamu vaizdavimas'[Parinkimas 4]) = "Su kasa", [USED OK Pardavimai],

0

)This is the formula

second max not works for me.

How to resolve this?

MAX('Pajamu vaizdavimas'[Parinkimas 4]) = "Be kasos", [USED Pardavimai be kasu], this is not used somehow

[Anonymous · Accepted solution]

Hi @Analitika ,

I create a sample to have a test. I think you can try this code to achieve your goal.

Sales Amount =
VAR _COUNT =
    CALCULATE ( DISTINCTCOUNT ( 'Pajamu vaizdavimas'[Parinkimas 4] ) )
RETURN
    IF (
        ISFILTERED ( 'Pajamu vaizdavimas'[Parinkimas 4] ),
        SWITCH (
            TRUE (),
            _COUNT = 2
                && MAX ( 'Pajamu vaizdavimas'[Parinkimas 4] ) IN { "Be kasos", "Su kasa" }, [USED OK Pardavimai],
            _COUNT = 1
                && MAX ( 'Pajamu vaizdavimas'[Parinkimas 4] ) = "Be kasos", [USED Pardavimai be kasu],
            _COUNT = 1
                && MAX ( 'Pajamu vaizdavimas'[Parinkimas 4] ) = "Su kasa", [USED OK Pardavimai],
            0
        ),
        0
    )

In my sample [USED Pardavimai be kasu] = 1 and [USED OK Pardavimai] = 2. Result is as below. 

No selection:

Select Be kasos:

Select Su kasa:

Select Both:

Best Regards,
Rico Zhou

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.