Forum Discussion

vickyprudhvi's avatar
vickyprudhvi
Icon for Helper IV rankHelper 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
Icon for Impactful Individual rankImpactful Individual
10 years ago
Var CURRENTID = Table[ID]
Return calculate (countrows(Table), Table[ID] = CURRENTID)
  • vickyprudhvi's avatar
    vickyprudhvi
    Icon for Helper IV rankHelper IV
    10 years ago

    austinsense

    Is that a calculated column or where is that dax returned

    • austinsense's avatar
      austinsense
      Icon for Impactful Individual rankImpactful Individual
      10 years ago
      Yep, calculated column
      • vickyprudhvi's avatar
        vickyprudhvi
        Icon for Helper IV rankHelper 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