Switch Function not giving expected result

[Anonymous]

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 · Accepted solution]

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]

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

[goncalogeraldes]

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