How can I count the values without VLOOKUP?

[Epinephrin]

Hello everyone,

I would like to check if a value in column A already has any value in column B (no matter which one).

Normally I would solve the problem with VLOOKUP:

=IF(VLOOKUP(A1;$A$1:$B$12;2;FALSE)>0; "Yes"; "No")

How can I enable this in Power BI?

Thanks in advance.

[Anonymous · Accepted solution]

Hi @Epinephrin ,

Something like below?

Column = IF('Table'[Column1] in VALUES('Table'[Column2]),"YES","NO")

Best Regards,

Jay

[amitchandak]

@Epinephrin ,

Try new column like

Count = countx(filter(Table,table[colA] =earlier(Table[ColB])),Table[ColB])

or

Flag = if(isblank(countx(filter(Table,table[colA] =earlier(Table[ColB])),Table[ColB])) ="No","Yes")

[Epinephrin]

Hey,

thank you. But the results from your first formular are empty and the second doesn't work because: 

DAX comparisons do not support comparisons between True/False and Text type(?).

[DebbieE]

Hi @Epinephrin

Have you got a few rows of example data to go with this?