Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago

is Manager? give 1 else 0

Hi Team,   I have a question looks pretty simple, but not able to have a crack at it.   I have two columns Emp ID and Manager ID.    I need a measure to get 1 when the emp ID is also listed in ...
Need Help
Anonymous's avatar
Anonymous
Not applicable
5 years ago

amitchandak   

I cant have a new column as there is a restriction from my company so i need a measure.  Would it be possible?

amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
5 years ago

Anonymous , Not tested yet, something like this

 

if(countx(filter(allselected(Table), [EmpID] =max([Mgr ID])),[Mgr ID])+0 >1,1,0)