Comparison of two columns passing on BLANKS

[Koliberus]

Hello, 

I created column with measure below for comparing two others columns:
Valid mails check = IF(EXACT('DATA1'[Mails], 'DATA2'[Mails]),1,0)

DATA1Mails	DATA2Mails	Valid mails check
user1@mail.com	user1@mail.com	1
user2@mail.com	user3@mail.com	0
user5@mail.com	user5@mail.com	1
blank	blank	1

The problem is that it also compares blank rows from both columns DATA1 and DATA2 and shows them as "1".
How can I exclude it and force to show "0" for exact blank values?

Best regards, 

Patrick

[saravanan_p · Accepted solution]

excude blanks in the filter level or give a condition in dax for not to comoare blanks, else if blank matches with blank then make it 0. It has to written in dax.
if(not(blank(DATA1'[Mails]),

     IF(EXACT('DATA1'[Mails], 'DATA2'[Mails]),1,0)
     ,0)

Hope this clears your query, kindly mark it as solution 

[Koliberus]

Thank You so much! Great help 🙂
Have a realy good day

Best Regards, 
Patrick

[msbiuser1]

@saravanan_p Perfect, well explained.
@Koliberus hence the solution, mark it so that users help the community