Comparing counts in two columns

[Vstukart]

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?

[v-rongtiep-msft · Accepted 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.

[Vstukart]

@amitchandak  please see below:

[amitchandak]

@Vstukart , Can you share sample data and sample output in table format?

Example column

if([columnA] > coalesce([Columnb],0) , true(), false())