Forum Discussion
vickyprudhvi
Helper IV
10 years agoDax 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
- vickyprudhvi
Helper IV
austinsense -Kindly help
- austinsense
Impactful Individual
Var CURRENTID = Table[ID]
Return calculate (countrows(Table), Table[ID] = CURRENTID)- vickyprudhvi
Helper IV
Is that a calculated column or where is that dax returned
- austinsense
Impactful Individual
Yep, calculated column