Total times values of a column appears in another column

[stalkerwolf2033]

Hello,

I need to know how to build a measure that allows me to know how many times an ID appears in another column (specifically, column "BOSS").

Measure should drop John: 2, because he is the boss of Andy and Tom

[v-cazheng-msft]

Hi @stalkerwolf2033,

May I know whether you have solved this issue? If you still have problems on it, could you please let me know whether there is any other table in your model and how you create relationships for these tables? In addition, how you create your visual? Thanks in advance!

If there is any post helps, then please consider Accept it as the solution to help the other members find it more quickly. If I misunderstand your needs or you still have problems on it, please feel free to let me know. Thanks a lot!

Best Regards,

Community Support Team _ Caiyun

[Fowmy · Accepted solution]

@stalkerwolf2033 

Create the following measure and apply

ID Count in Boss = 
VAR __ID = SELECTEDVALUE(Table1[ID])
RETURN
CALCULATE(
    COUNTA( Table1[BOSS] ),
    Table1[BOSS] = __ID,
    REMOVEFILTERS(Table1)
)

[stalkerwolf2033]

Hi! I tried this but it returns the same number for all columns