Forum Discussion
Help on Calculation
Hello guys!
Anyone would be able to help me on the following 2 queries that I am stuck in. I have tried few different things but no success. I am trying to do up a graphs for some specific scenarios.
I have different csv files for different rounds, Round 1, Round 2, Round 3 and so on. In every file I have a Round and AccountID column, Account ID is unique across them. Structure example is at the bottom below.
My difficulties are:
1. I want to do up a graph where will show the number of users who played the the current round but also played the last 3, for example, users who played the Round 4 but also played the Round 1, 2 and 3;
2. My second query is, I would like to show a graph where it shows the Total number of users in a round and also to show the Number of NEW USERS. For example, who is a New User on Round 4 who was not in Round 1, 2 and 3.
csv. files structure example:
Round | AccountID
1 | 256981
1 | 563952
1 | 585223
1 | 112598
Round | AccountID
2 | 115698
2 | 598652
2 | 256981
2 | 112598
Really appreciate any help!! Thank you!
3 Replies
Please share the full data structure
You may create 2 measures as follows:
All Rounds Players = IF ( CALCULATE ( COUNTROWS ( Data ), ALLEXCEPT ( Data, Data[Username] ) ) = 4, "AllRoundsPlayer" )Count of New Players = COUNTROWS ( FILTER ( ADDCOLUMNS ( SUMMARIZE ( Data, Data[Username] ), "ROUND4", CALCULATE ( COUNTROWS ( Data ), Data[Round] = 4 ), "AllRounds", CALCULATE ( COUNTROWS ( Data ) ) ), [AllRounds] = 1 && [ROUND4] = 1 ) )You may check this sample file.
