Match formula in DAX (Excel formula alternative)

[JWO16]

I've created a dashboard that in the main brings back info directly from another solution.  I've a few fields that I've had to create and use myself though.  The one I'm struggling with though is a field to flag when a field value is also in another record in the data (the parent column)

This is the formula I've used previously in my Excel workbook.  Is DAX capable of handling this and how could I go about doing the same so I can bring it into my PowerBI dashboard.

=IF(ISNUMBER(MATCH([@[Work Item ID]],[Parent Work Item Id],0)),"Y","N")

[ahmadibrahimbus · Accepted solution]

Please Use This Formula and mark my Answer as solution if it's Solved.

= if(CALCULATE(COUNTROWS('Table'),FILTER( 'Table', 'Table'[Parent Work Item ID] = EARLIER('Table'[Work Item ID])))>0,"Y","N").

Nb: include this dax formula as new calculated column.