How to create alert if the value is present 2 times in the same column?

[Mikahel369]

Hi there,

my need is to color 2 cells of the same column if they have the same value or anyway to make evident that there is a matching between 2 rows, for example:

REF	COLORTHAT
ABC	THISYES
DEF	THISNO
GHI	THISYES

I think the solution should be in Select column and using a Count Distinct, in this way in presence of a double or more values I should know if this cell value is repeated, but I really don't know how to do that.

Please help.

thanks

[Mikahel369]

As always happen to me, when I make the question I found the solution... and actually was still here but with another "title":

Solved: How to count the occurrence of values in a column ... - Microsoft Power BI Community

after created the measure I just created the conditional formatting over the new column (new measure) and over the cell it self that shown the same values.

May help someone else. 

[Greg_Deckler · Accepted solution]

@Mikahel369 Perhaps a calculated column like this:

Count the Same Column =
  COUNTROWS(FILTER('Table',[COLORTHAT] = EARLIER(Table[COLORTHAT])))

Then a rule that if this column > 1, show as red.

[Mikahel369]

Ok great, this is even better than what I found.

Thanks