Forum Discussion

jvilchez's avatar
jvilchez
New Member
9 years ago
Solved

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. Likewi...
Need Help
  • v-sihou-msft's avatar
    v-sihou-msft
    9 years ago

    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,

v-sihou-msft's avatar
v-sihou-msft
Microsoft Employee
9 years ago

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,