topic Remove line from the code in DAX Commands and Tips

Remove line from the code

sdhn — Mon, 10 Jan 2022 23:04:05 GMT

Hi All,

I have existing calculalted column code as below:

Graphs =

SWITCH(

TRUE(),

[Vulnerable (Yes/No/Not Assessed)] = "NOT ASSESSED"

|| [Vulnerable (Yes/No/Not Assessed)] = "UNKNOWN", "NOT ASSESSED",

[Vulnerable (Yes/No/Not Assessed)] = "YES"

|| [Vulnerable (Yes/No/Not Assessed)] = "NO", "ASSESSED"

Now there is no value for UNKNOWN. we need to remove UNKNOWN from the code.

Logic one should be "NOT ASSESSED is NOT ASSESSED". Rest os fine.

I removed this row || [Vulnerable (Yes/No/Not Assessed)] = "UNKNOWN", "NOT ASSESSED", but getting errors.

help will be appreciated. Thanks

Re: Remove line from the code

VahidDM — Mon, 10 Jan 2022 23:19:40 GMT

Hi sdhn

Try this:

Graphs = SWITCH ( TRUE (), [Vulnerable (Yes/No/Not Assessed)] = "NOT ASSESSED", "NOT ASSESSED", [Vulnerable (Yes/No/Not Assessed)] = "YES" || [Vulnerable (Yes/No/Not Assessed)] = "NO", "ASSESSED" )

Graphs = IF ( [Vulnerable (Yes/No/Not Assessed)] = "NOT ASSESSED", "NOT ASSESSED", "ASSESSED" )

If this post helps, please consider accepting it as the solution to help the other members find it more quickly.
Appreciate your Kudos!!
LinkedIn: www.linkedin.com/in/vahid-dm/

Re: Remove line from the code

sdhn — Mon, 10 Jan 2022 23:52:43 GMT

Thanks