CalCulated/Dynamic measure to count the number of Same Rows based on Column ID

[karthik69]

Hello All,

Thanks for seeing this Post.

I'm trying to find a way to caluculate the number of Rows with same IDS and put in a Seperate Dynamic measure/Column.

My Dataset looks like  below

if we see the above table, Microsoft was repeated two times , So countofIDs Column is 2 for both the rows.

Similar for Salesforce. So how can we achieve this via Measure/Column

Regards

Karthik

[johnt75 · Accepted solution]

Try

Num IDs =
CALCULATE (
    COUNTROWS ( 'Table' ),
    REMOVEFILTERS ( 'Table' ),
    VALUES ( 'Table'[ID] )
)