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
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

     

    • austinsense's avatar
      austinsense
      Icon for Impactful Individual rankImpactful Individual
      10 years ago
      Either way, those two formulas produce the exact same result.
      • vickyprudhvi's avatar
        vickyprudhvi
        Icon for Helper IV rankHelper IV
        10 years ago

        austinsense

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