Microsoft Fabric Community Conference 2025, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount.
Register nowThe Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.
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
Solved! Go to 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
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
Thank You so much! Great help 🙂
Have a realy good day
Best Regards,
Patrick
@saravanan_p Perfect, well explained.
@Koliberus hence the solution, mark it so that users help the community
User | Count |
---|---|
21 | |
20 | |
12 | |
10 | |
8 |
User | Count |
---|---|
30 | |
27 | |
14 | |
13 | |
11 |