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

karthik69 — Tue, 01 Nov 2022 11:48:48 GMT

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

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

johnt75 — Tue, 01 Nov 2022 11:56:00 GMT

Try

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