Need Help EARLIER

[jvilchez]

Greetings,
I have the following query, I have a table that contains 7500 registers approx; And what I want to do is a measure that helps me show the percentage of user participation per year.

Likewise, every year the users increase; Example in 2014 there were 89 users, in 2015 1500 users and by 2016 there were 2215 users.

But the participation of the mentioned years is the following 2014: 32; 2015: 152; And 2016: 350.

The percentage of participation would be for 2014 = (32/89), 2015 = (152 / (1500 + 89)) and 2016 = (350 / (2215 + 1500 + 89)).
Use the function earlier, and get it counted and users increase by year:

CALCULATE(COUNT('vmc_subastas_consultas DIM_USUARIO'[ID_USUARIO]);FILTER('vmc_subastas_consultas DIM_USUARIO';'vmc_subastas_consultas DIM_USUARIO'[FECHA_REGISTRO].[Año]<=EARLIER('vmc_subastas_consultas DIM_USUARIO'[FECHA_REGISTRO].[Año]));FILTER('vmc_subastas_consultas DIM_USUARIO';'vmc_subastas_consultas DIM_USUARIO'[ESTADO]="ACTIVO");FILTER('vmc_subastas_consultas DIM_USUARIO';'vmc_subastas_consultas DIM_USUARIO'[DEMO]=0);FILTER('vmc_subastas_consultas DIM_USUARIO';'vmc_subastas_consultas DIM_USUARIO'[COD_CLI]=0))

And this is repeated in all my records; And when I show it I get the following:

Does not give me the information I want and adds the records with the values ​​of the years, and can only give me the result when I change the option to averag

And generating my measure only gives me other values ​​that are not mentioned in the above lines.

Some help?
Thanks..... 

[v-sihou-msft · Accepted solution]

@jvilchez

In this scenario, to calculate the percentage of participation every year, you just need to use the current year participation divided by cumulative users. Please refer to measure below:

Participation Rate = SUM([Participation])/CALCULATE(SUM(Table1[Users]),FILTER(ALL(Table1[Year]),Table1[Year]<=MAX(Table1[Year])))

Regards,