SWITCH help with blank()

[kasiak]

Hi,

I wanted to create new column with formula below:

column_3 =

SWITCH(

TRUE (),

'file'[office] = BLANK() &&

'file'[Current Task] = "Record Completed" &&

'file'[Service Status] = "No issues" &&

'file'[No Filing Requirement] = "No",

"1",

"0")

However, while filtering new column_3 & see that there's one row in [office] column that contains data, while it should be blank. What am I doing wrong? 

Thank you for your support.

Kasia

[kasiak]

Thank you Greg @Greg_Deckler for your reply. I'm not sure if I understand correct 🙂

So, is the first condition wrong? My aim is to show only blank rows within office column, but only if other conditions are met too:

'file'[Current Task] = "Record Completed" &&

'file'[Service Status] = "No issues" &&

'file'[No Filing Requirement] = "No"

Could you please clarify? I'm a beginner in dax:) thank you!

[Greg_Deckler]

@kasiak The way your formula is written, it will either return 1 or 0, never blank.

[kasiak · Accepted solution]

Thank you @Greg_Deckler I think I solved it 🙂

Thanks!

BR,

Kasia