Forum Discussion

vickyprudhvi's avatar
vickyprudhvi
Helper IV
10 years ago

Dax Calculated Column for Repeat Count

Hi, ID          Amt                 CalculatedColumn 1           1000                           3 1           2000                           3 1           3000                           3 2     ...
Need Help
austinsense's avatar
austinsense
Impactful Individual
10 years ago
Var CURRENTID = Table[ID]
Return calculate (countrows(Table), Table[ID] = CURRENTID)
vickyprudhvi's avatar
vickyprudhvi
Helper IV
10 years ago

austinsense

Is that a calculated column or where is that dax returned

  • austinsense's avatar
    austinsense
    Impactful Individual
    10 years ago
    Yep, calculated column
    • vickyprudhvi's avatar
      vickyprudhvi
      Helper IV
      10 years ago

      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's avatar
        austinsense
        Impactful Individual
        10 years ago
        Either way, those two formulas produce the exact same result.