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
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.
  • vickyprudhvi's avatar
    vickyprudhvi
    Helper 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
      Helper IV
      10 years ago

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

      • austinsense's avatar
        austinsense
        Impactful Individual
        10 years ago

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