topic Re: Switch Function not giving expected result in DAX Commands and Tips

Switch Function not giving expected result

Anonymous — Fri, 18 Mar 2022 13:12:38 GMT

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

Re: Switch Function not giving expected result

goncalogeraldes — Fri, 18 Mar 2022 13:12:31 GMT

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

Re: Switch Function not giving expected result

Anonymous — Fri, 18 Mar 2022 13:15:08 GMT

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

Re: Switch Function not giving expected result

v-angzheng-msft — Fri, 25 Mar 2022 05:56:32 GMT

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.