If with Filter

[INJAINP]

Hello Folks,

I have a requirement as follows :

there are 3 values in slicer. Suppose the are A , B and C. If A gets selected then a measure value corresponding to A should be displayed and similarly with B and C. but if none of them gets slecteed then va;lue should be 20% of A + 60% of B + 20% of C this should be displayed.

any idea how can this be achieved? I tried using if else with filter but it says multiple columns used and does not give correct formula.

Thanks

[v-chuncz-msft · Accepted solution]

@INJAINP,

You may refer to the DAX below.

Measure =
VAR s =
    SELECTEDVALUE ( Table1[Column1] )
RETURN
    IF (
        ISBLANK ( s ),
        SUMX (
            VALUES ( Table1[Column1] ),
            CALCULATE (
                SWITCH ( SELECTEDVALUE ( Table1[Column1] ), "A", 0.2, "B", 0.6, "C", 0.2 )
                    * SUM ( Table1[Column2] )
            )
        ),
        SUM ( Table1[Column2] )
    )

[LivioLanzo]

Hi @INJAINP could be done but we need to see your tables

[luxpbi]

Please, provide samplea data to help you better.

Regards,