Forum Discussion

RNZALR's avatar
RNZALR
Helper I
3 years ago
Solved

Player Retention Rates

Hello,   I’m looking for some dax that will calculate retention rates for me. I’m building a report for a sports body where the season starts on 1 November each year. I have a table with player reg...
  • Jihwan_Kim's avatar
    Jihwan_Kim
    3 years ago

    Hi,

    Thank you for your message.

    I am not sure how your desired outcome of a visualization looks like, but please check the below picture and the attached pbix file. I tried to create it by using my sample data.

     

     

     

     

    All measures are in the attached pbix file.

     

Jihwan_Kim's avatar
Jihwan_Kim
Super User
3 years ago

Hi,

Thank you for your message.

I am not sure how your desired outcome of a visualization looks like, but please check the below picture and the attached pbix file. I tried to create it by using my sample data.

 

 

 

 

All measures are in the attached pbix file.

 

cwillems's avatar
cwillems
New Member
3 years ago

Hi Jihwan_Kim,

 

I tried using your PBIX file to recreate as I am trying to solve a similar problem for a sports club. See the table I got using your dax measure:

 

 

For your reference, this is my datamodel:

 

Here is some of the data I am working with (some fields are calculated columns):

 

I would like to be able to show when a player is playing their first season, when they have left. That way I will be able to show a retention %: players staying/total players that year. I will then show this percentage per age group, coach, etc. Do you have any imput on this? 

 

Thanks & appreciate your insights!