Dax Calculated Column for Repeat Count

[vickyprudhvi]

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

[austinsense]

Var CURRENTID = Table[ID]
Return calculate (countrows(Table), Table[ID] = CURRENTID)

[vickyprudhvi]

@austinsense

Is that a calculated column or where is that dax returned

[austinsense]

Yep, calculated column

[vickyprudhvi]

@austinsense

do u mean this

CALCULATE(COUNTROWS(Table),Table[Id]=EARLIER(Table'[Id]))

I am not sure how to write VAR or return function in Tabular Model DAX

[austinsense]

Either way, those two formulas produce the exact same result.

[vickyprudhvi]

@austinsense

Its not working with my formular it repeating total count of table instead of repeating total count for each ID

[vickyprudhvi]

@austinsense btw I am using Tabular model 2012 and not 2016 so VAR anc Return function is not available

[austinsense]

Yep, sorry we should have covered that sounds like you got the problem solved?

[vickyprudhvi]

@austinsense -Kindly help