Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

Switch Function not giving expected result

Hello Forum,

I want to create a calculated column which uses a value from another column and result is based upon that but it is giving me blank Dax for calculated column as below

Column = switch('Table'[Column1],"a",CALCULATE(sum('Table'[Column2]),'Table'[Column1]="f",'Table'[Column3]=2020))
Data set as follows

Could you please help me to find out the solution amitchandak  AlexisOlson Greg_Deckler 

Thanks in advance

 

  • v-angzheng-msft's avatar
    v-angzheng-msft
    4 years ago

    Hi, Anonymous 

     

    Try this:

    Column = 
SWITCH (
    'Table'[Column1],
    "a",
        CALCULATE (
            SUM ( 'Table'[Column2] ),
            ALL('Table'),
            'Table'[Column1] = "f",
            'Table'[Column3] = 2020
        )
)

    Result:

    Please refer to the attachment below for details.

    Hope this helps.

     

     

    Best Regards,
    Community Support Team _ Zeon Zheng


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

3 Replies

  • goncalogeraldes's avatar
    goncalogeraldes
    Super User
    4 years ago

    Hello there Anonymous ! Check if this solves your problem:

    Column =
SWITCH (
    SELECTEDVALUE ( 'Table'[Column1] ),
    "a",
        CALCULATE (
            SUM ( 'Table'[Column2] ),
            'Table'[Column1] = "f",
            'Table'[Column3] = 2020
        )
)

    Hope this answer solves your problem!
    If you need any additional help please @ me in your reply.
    If my reply provided you with a solution, please consider marking it as a solution ✔️ or giving it a kudoe 👍
    Thanks!

    You can also check out my LinkedIn!

    Best regards,
    Gonçalo Geraldes

  • v-angzheng-msft's avatar
    v-angzheng-msft
    Community Support
    4 years ago

    Hi, Anonymous 

     

    Try this:

    Column = 
SWITCH (
    'Table'[Column1],
    "a",
        CALCULATE (
            SUM ( 'Table'[Column2] ),
            ALL('Table'),
            'Table'[Column1] = "f",
            'Table'[Column3] = 2020
        )
)

    Result:

    Please refer to the attachment below for details.

    Hope this helps.

     

     

    Best Regards,
    Community Support Team _ Zeon Zheng


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

  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

    Hello goncalogeraldes  thanks for your reply tried with your solution but still gives same blank