Forum Discussion

afrutos's avatar
afrutos
Resolver I
4 years ago
Solved

Cumulative count

Hi everyne,  I need some help here, thanks in advanced I need to calculate de cumulative of new members entering from a date I need to calculate the number of new members from those who had join...
Need Help
Tips and Tricks
  • v-yanjiang-msft's avatar
    v-yanjiang-msft
    4 years ago

    Hi afrutos ,

    According to your description, I guess the [IdEntity] column should be of text type, modify the formula of this part to Authors[IdEntity]="01".

    Best Regards,
    Community Support Team _ kalyj

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

amitchandak's avatar
amitchandak
Super User
4 years ago

afrutos , try a measure like

 


FIRSTDATE500 = CALCULATE(DISTINCTCOUNT(Query1[IdAuthor]),Filter(allselected(Authors), Authors[IdEntity]=01 && isblank(Authors[DateDeceased]) && isblank( Authors[DateDeceased])
&& Authors[Age]<=80 && Authors[dateMost500]< date(2021,04,11) && Authors[dateMost500]<= max(Authors[dateMost500]) ))

  • afrutos's avatar
    afrutos
    Resolver I
    4 years ago

    Hi it returns me an error,
    "DAX comparison operations do not support comparison values of type Text with values of type Integer."
    An I think it is because of IdAutor, an exampe of IdAutor is "AUT150595"

    But I don't know how to solve it, I've tried using Values but not working

    • v-yanjiang-msft's avatar
      v-yanjiang-msft
      Community Support
      4 years ago

      Hi afrutos ,

      According to your description, I guess the [IdEntity] column should be of text type, modify the formula of this part to Authors[IdEntity]="01".

      Best Regards,
      Community Support Team _ kalyj

      If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.