Forum Discussion

INJAINP's avatar
INJAINP
Frequent Visitor
7 years ago
Solved

If with Filter

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

 

Need Help
  • v-chuncz-msft's avatar
    v-chuncz-msft
    7 years ago

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

3 Replies

  • luxpbi's avatar
    luxpbi
    Helper V
    7 years ago

    Please, provide samplea data to help you better.

     

    Regards,

  • v-chuncz-msft's avatar
    v-chuncz-msft
    Community Support
    7 years ago

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