If this == this or this

[andytmcc]

I have a filter that includes the line 'Loneliness All Data'[VARIABLE] == "Parliamentary Constituency". I also want this filter to include "LGD" i.e, if the variable column is equal to Parliamentary Constituency or LGD. How do I add in the LGD? I'm sure this must be easy but I'm a newbie and can't figure it out at all! 

 Here is my code: 

LOC Previous Year =

VAR PreviousRow =

TOPN (

1,

FILTER (

'Loneliness All Data',

'Loneliness All Data'[YEAR] < EARLIER ( 'Loneliness All Data'[YEAR] )

&& 'Loneliness All Data'[CATEGORY] = EARLIER ( 'Loneliness All Data'[CATEGORY] ) && 'Loneliness All Data'[VARIABLE] == "Parliamentary Constituency"

),

[YEAR], DESC

)

VAR PreviousValue =

MINX ( PreviousRow, [Locus Of Control Mean] )

RETURN

PreviousValue

[andytmcc]

@ReneMoawad  How would I put this same filter requirement FILTER('Loneliness All Data'[VARIABLE] IN {"Parliamentary Constituency", "LGD"} into this code:

LOC_conditionalFormat =

SWITCH (

TRUE (),

OR (

ISBLANK ( 'Loneliness All Data'[Locus Of Control Mean] ),

ISBLANK ( 'Loneliness All Data'[LOC Previous Year] )

), 4,

'Loneliness All Data'[Locus Of Control Mean] > 'Loneliness All Data'[LOC Previous Year], 1,

'Loneliness All Data'[Locus Of Control Mean] < 'Loneliness All Data'[LOC Previous Year], 2,

'Loneliness All Data'[Locus Of Control Mean] = 'Loneliness All Data'[LOC Previous Year], 3

)

Thanks!

[ReneMoawad]

LOC_conditionalFormat =

SWITCH (TRUE()

    , ISBLANK ('Loneliness All Data'[Locus Of Control Mean]) || ISBLANK('Loneliness All Data'[LOC Previous Year]), 4

    , 'Loneliness All Data'[Locus Of Control Mean] > 'Loneliness All Data'[LOC Previous Year], 1

    , 'Loneliness All Data'[Locus Of Control Mean] < 'Loneliness All Data'[LOC Previous Year], 2

    , 'Loneliness All Data'[Locus Of Control Mean] = 'Loneliness All Data'[LOC Previous Year], 3

)

[andytmcc]

Sorry, i didn't mean how would I use the || in that. I meant how would I put this filter FILTER('Loneliness All Data'[VARIABLE] IN {"Parliamentary Constituency", "LGD"} into this code below:

LOC_conditionalFormat =

SWITCH (

TRUE (),

OR (

ISBLANK ( 'Loneliness All Data'[Locus Of Control Mean] ),

ISBLANK ( 'Loneliness All Data'[LOC Previous Year] )

), 4,

'Loneliness All Data'[Locus Of Control Mean] > 'Loneliness All Data'[LOC Previous Year], 1,

'Loneliness All Data'[Locus Of Control Mean] < 'Loneliness All Data'[LOC Previous Year], 2,

'Loneliness All Data'[Locus Of Control Mean] = 'Loneliness All Data'[LOC Previous Year], 3

)

[ReneMoawad]

LOC_conditionalFormat =

Var output = SWITCH (

TRUE (),

OR (

ISBLANK ( 'Loneliness All Data'[Locus Of Control Mean] ),

ISBLANK ( 'Loneliness All Data'[LOC Previous Year] )

), 4,

'Loneliness All Data'[Locus Of Control Mean] > 'Loneliness All Data'[LOC Previous Year], 1,

'Loneliness All Data'[Locus Of Control Mean] < 'Loneliness All Data'[LOC Previous Year], 2,

'Loneliness All Data'[Locus Of Control Mean] = 'Loneliness All Data'[LOC Previous Year], 3

)

RETURN
IF(All Data'[VARIABLE] IN {"Parliamentary Constituency", "LGD"}, output, BLANK())

[andytmcc]

Thank you so much!

[andytmcc]

Hi @ReneMoawad , 

That's fantastic - thank you so much! I had been trying to use OR but couldn't figure it out. First time coming across IN for me!

[ReneMoawad]

Also instead of OR you can use double vertical bar ||

[ReneMoawad · Accepted solution]

Hi @andytmcc,

You can use it like this && 'Loneliness All Data'[VARIABLE] IN {"Parliamentary Constituency", "LGD"}