Need hep

Hi sekharsahu25 ,

 According to your expected output,

• if [Accnt]="Cost of Revenue",then TRUE() and need to get the $ from Table 1 based on each iDept id and
• if [Accnt]="Operating Revenue", then False()

If so, please try:

Duplicate = IF([Accnt]="Cost of Revenue",TRUE(),FALSE())

$ = 
var _look=CONVERT( LOOKUPVALUE('Table 1'[$],[Dept ID],[Dept Id]) ,STRING)
return IF( [Accnt]="Cost of Revenue","FALSE", IF( _look=BLANK(),"#N/A",_look))

Best Regards,
Eyelyn Qin
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Hi sekharsahu25 ,

P;ease try:

Duplicate = 
var _count=CALCULATE(COUNTROWS('Table 2'),ALLEXCEPT('Table 2','Table 2'[Dept Id]))
var _rank=RANKX(FILTER('Table 2',[Dept Id]=EARLIER('Table 2'[Dept Id])),[Accnt],,ASC)
return IF(_count>1 && _rank=1,TRUE())

Best Regards,
Eyelyn Qin
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.