Forum Discussion
vickyprudhvi
10 years agoHelper IV
Dax Calculated Column for Repeat Count
Hi,
ID Amt CalculatedColumn
1 1000 3
1 2000 3
1 3000 3
2 10 2
2 20 2
I want to creat a calculated column where it counts number of id's repeated and shows same value for all rows for that ID
(as showned in above table). Kindly let me know how to create calculatedColumn for this
Thank you
9 Replies
- vickyprudhviHelper IV
austinsense -Kindly help
- austinsenseImpactful IndividualVar CURRENTID = Table[ID]
Return calculate (countrows(Table), Table[ID] = CURRENTID)- vickyprudhviHelper IV
Is that a calculated column or where is that dax returned
- austinsenseImpactful IndividualYep, calculated column