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

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

      • austinsense's avatar
        austinsense
        Icon for Impactful Individual rankImpactful Individual
        10 years ago

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