Empty Values not appearing as (Blank)

[Anonymous]

Hi all,

I'm realtively new to Power BI, and I've been attempting to create a mailing list for clients - I've created a measure that priotises main emails and alternate emails based on their main entity status to ensure.

Primary Email =

SWITCH (

TRUE (),

Clients[Contacts.Contact.IsPrimary] = "Yes", IF (

ISBLANK ( Clients[Contacts.Contact.Email] ),

Clients[Email],

Clients[Contacts.Contact.Email]

),

Clients[Contacts.Contact.IsPrimary] = "No", IF (

ISBLANK ( Clients[Email] ),

Clients[Contacts.Contact.Email],

Clients[Email]

),

ISBLANK ( Clients[Contacts.Contact.IsPrimary] ), IF (

ISBLANK ( Clients[Contacts.Contact.Email] ),

Clients[Email],

Clients[Contacts.Contact.Email]

),

BLANK()

)

However, I'm encountering an issue where empty values are not appearing as blanks. These values are not spaces either, I've attempted to eliminate any kind of possibility of this happening, however I still can't seem to avoid this issue and I'm losing more emails than I'd like to (none).

Any ideas as to what could cause this?

Thank you!

[dax]

Hi @Anonymous , 

I am not clear about your problem, as I know, when there is blank in rows, it will show (blank)  as blank option in power query filter and show blank in design filter, this is default. So what is your problem now? If possible, could you please inform me more detailed information(such as your expected output and your sample data (by OneDrive for Business))? Then I will help you more correctly.

Please do mask sensitive data before uploading.

Thanks for your understanding and support.
Best Regards,
Zoe Zhi

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[amitchandak · Accepted solution]

You may have to handle it

if(Clients[Contacts.Contact.Email]="",blank(),Clients[Contacts.Contact.Email])