Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and a 50 percent discount on exams.
Get startedEarn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
I'm trying to compare count in two columns.
Column A is guaranteed to have a value in it that is bigger or equal to 1, whereas column B doesn't necessarily have any value in it (seems to return blank when 0). I would like to be able to flag all rows where Column A doesn't match Column B.
Can anyone please help me out on how to do this and not get errors for the blank cells?
Solved! Go to Solution.
Hi @Vstukart ,
Please have a try.
Create measures.
count number = COUNT('Table'[Number Check])
count service = COUNT('Table'[SERVICEJOBID])
Measure = IF([count number]>=1&&[count service]<>0,BLANK(),"MARK")
Best Regards
Community Support Team _ Polly
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi @Vstukart ,
Please have a try.
Create measures.
count number = COUNT('Table'[Number Check])
count service = COUNT('Table'[SERVICEJOBID])
Measure = IF([count number]>=1&&[count service]<>0,BLANK(),"MARK")
Best Regards
Community Support Team _ Polly
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
@Vstukart , Can you share sample data and sample output in table format?
Example column
if([columnA] > coalesce([Columnb],0) , true(), false())