Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
tomhopewell
Frequent Visitor

Activer Players per Month

Hi,

 

I am trying to calculate the number of "Active Players" per month. The classification for "Active Player" is anyone who has played a game in that month.

 

I have:

- Player dimension which has a player's unique Login

- Date dimension

- PlayerGame Fact table which lists all games played by a player (links to Player on PlayerKey and Date on GameDateKey)

 

I am new to DAX so apologies if this is a simple request. I can provide more information if needed.

 

Thanks in advance,

Tom

1 ACCEPTED SOLUTION
Stachu
Community Champion
Community Champion

try this measure

ActivePlayers = DISTINCTCOUNT(PlayerGame[PlayerKey])

then put Year & month in rows in the table and the measure as values



Did I answer your question? Mark my post as a solution!
Thank you for the kudos 🙂

View solution in original post

2 REPLIES 2
Stachu
Community Champion
Community Champion

try this measure

ActivePlayers = DISTINCTCOUNT(PlayerGame[PlayerKey])

then put Year & month in rows in the table and the measure as values



Did I answer your question? Mark my post as a solution!
Thank you for the kudos 🙂

Thanks very much.

 

I should have mentioned my DimPlayer table was a Type 2 Slowly Changing Dimension so i had to change your DAX slightly to this...

 

ActivePlayers = COUNTROWS(SUMMARIZE('PlayerGame','Dim Player'[Login]))
 
Thanks again

Helpful resources

Announcements
Europe Fabric Conference

Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

Power BI Carousel June 2024

Power BI Monthly Update - June 2024

Check out the June 2024 Power BI update to learn about new features.

RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.