Counting matching duplicates from another column

Question

I can't figure out a way to calculate the repeat of an ID based on a key column.&nbsp;For examplekey&nbsp; &nbsp; &nbsp; &nbsp;|&nbsp; &nbsp; related&nbsp; &nbsp;| counta0001&nbsp; &nbsp;|&nbsp; &nbsp; (blank)&nbsp; &nbsp;|&nbsp; &nbsp; 3a0002&nbsp; &nbsp;|&nbsp; &nbsp;a0004&nbsp; &nbsp; &nbsp;|&nbsp; &nbsp;0a0003&nbsp; &nbsp;|&nbsp; &nbsp;a0004&nbsp; &nbsp; &nbsp;|&nbsp; &nbsp;0a0004&nbsp; &nbsp;|&nbsp;&nbsp; (blank)&nbsp; &nbsp; |&nbsp; &nbsp;2a0005&nbsp; &nbsp;|&nbsp; &nbsp;a0001&nbsp; &nbsp; &nbsp;|&nbsp; &nbsp;0a0006&nbsp; &nbsp;|&nbsp; &nbsp;a0001&nbsp; &nbsp; &nbsp;|&nbsp; &nbsp;0a0007&nbsp; &nbsp;|&nbsp; &nbsp;a0001&nbsp; &nbsp; &nbsp;|&nbsp; &nbsp;0&nbsp;Trying to figure out the count of the related repeats based on the key.

anonymous · Accepted Answer

CountRepeat = var thisRecord = [key]RETURN
CALCULATE(
        countrows('YourTable'),
        all('YourTable'),
        'YourTable'[related] = thisRecord
)

Forum Discussion

Counting matching duplicates from another column

1 Reply

Related content

Column count duplicates

Count duplicate values

Duplicate ranking

Counting nulls

issue count number of matching values.