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

      • vickyprudhvi's avatar
        vickyprudhvi
        Icon for Helper IV rankHelper IV
        10 years ago

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