Forum Discussion

jvilchez's avatar
jvilchez
New Member
9 years ago

Need Help earlier

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 average

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

1 Reply

  • v-yulgu-msft's avatar
    v-yulgu-msft
    Microsoft Employee

    Hi jvilchez,

     

    The image you uploaded was destroyed, I cannot see your source table structure and the result output. Please share your sample data and expected result again so that I can reproduce your scenario.

     

    To upload images successfully, please don't insert images inside the Code textbox, please click the Photos button in the toobar.

     

    Best regards,
    Yuliana Gu