IF / OR Statement

[Topgunz786123]

 Good afternoon All,

I wanted to know how to use IF / OR statement for the following:

I have client buckets such as TX, SC, and RC. What I want is if there is a Current Client in TX or a Current Client in SC or a Current Client in RC, to produce a value. If there isn't a Current Client in either of the three buckets, to produce a value of none / blank.

I tried this but it didnt' work:

Column = if('AccountAsset-WhiteSpace-GraySpace'[TX]="Current Client", OR('AccountAsset-WhiteSpace-GraySpace'[SC]="Current Client", OR('AccountAsset-WhiteSpace-GraySpace'[RC]="Current Client")))

Is there an easy way to do this?

[Anonymous · Accepted solution]

Hi @Topgunz786123

Ty this.

Column = IF('AccountAsset-WhiteSpace-GraySpace'[TX]="Current Client" ||'AccountAsset-WhiteSpace-GraySpace'[SC]="Current Client" ||'AccountAsset-WhiteSpace-GraySpace'[RC]="Current Client", "YOUR_VALUE" , BLANK() )

You can apply a page filter on this colun for "YOUR _VALUE".

Thanks

Raj

[Anonymous · Accepted solution]

Hi @Topgunz786123

Ty this.

Column = IF('AccountAsset-WhiteSpace-GraySpace'[TX]="Current Client" ||'AccountAsset-WhiteSpace-GraySpace'[SC]="Current Client" ||'AccountAsset-WhiteSpace-GraySpace'[RC]="Current Client", "YOUR_VALUE" , BLANK() )

You can apply a page filter on this colun for "YOUR _VALUE".

Thanks

Raj

[Topgunz786123]

I tried this:

Column = if('AccountAsset-WhiteSpace-GraySpace'[TX]="Current Client", 'AccountAsset-WhiteSpace-GraySpace'[SC]="Current Client", 'AccountAsset-WhiteSpace-GraySpace'[RC]="Current Client", "True", BLANK())

but getting the message "Too many arguments were passed to the IF function. The maximum argument count for the function is 3"

[Anonymous · Accepted solution]

The syntax of IF is not correct. Please check the one i have provided above.

Thanks

Raj

[Topgunz786123]

The syntax your provided above worked perfectly.

Thank you Raj, for all of your help. 

[nirvana_moksh]

Did you want something like below:

[Topgunz786123]

This looks great; however, I want to be able to filter out Current Clients that are in TX or SC or RC. If clients are in TX or SC or RC, I want to use that on the page filter.