Coding for (Blank)

[MEFOX]

I'm trying to categorize the blanks into the group "Canceled". My Dax is below and below that is the filter for the field that I'm writing the DAX against. I've tried "Blank" and "blank" and "(Blank)" in my If statement but none have catagorized the blanks into the "Canceled" group. How do you capture blanks in DAX? 

if ('CRM DimCampaignStatus'[CampaignStatusValue] in {"Canceled","Inactive","Postponed","Suspended","(Blank)","Unkown"}, "Canceled",

[jdbuchanan71 · Accepted solution]

@MEFOX 

Try it like this

if (
	'CRM DimCampaignStatus'[CampaignStatusValue] in {"Canceled","Inactive","Postponed","Suspended","Unkown"} || 
	ISBLANK ( 'CRM DimCampaignStatus'[CampaignStatusValue], 
	"Canceled",

|| in this is OR

[v-yanjiang-msft]

Hi @MEFOX ,

Is your problem solved?? If so, Would you mind accept the helpful replies as solutions? Then we are able to close the thread. More people who have the same requirement will find the solution quickly and benefit here. Thank you.

Best Regards,
Community Support Team _ kalyj

[sevenhills]

Replace "(Blank)" with BLANK()

[parry2k · Accepted solution]

@MEFOX and you can also do this, 

if (
	'CRM DimCampaignStatus'[CampaignStatusValue] in {"Canceled","Inactive","Postponed","Suspended","Unkown", BLANK() },
	"Canceled",
        "else value"
)

✨ Follow us on LinkedIn and  to our YouTube channel

I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make effort to give Kudos to whoever helped to solve your problem. It is a token of appreciation!

⚡ Visit us at https://perytus.com, your one-stop shop for Power BI-related projects/training/consultancy.

[jdbuchanan71 · Accepted solution]

@MEFOX 

Try it like this

if (
	'CRM DimCampaignStatus'[CampaignStatusValue] in {"Canceled","Inactive","Postponed","Suspended","Unkown"} || 
	ISBLANK ( 'CRM DimCampaignStatus'[CampaignStatusValue], 
	"Canceled",

|| in this is OR