Help on Calculation

[eapo12]

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!

[Mohammad_Refaei]

Please share the full data structure

[eapo12]

Hi there, thank you for the reply!
Structure as below (The data will have over 10k rows).

[Mohammad_Refaei]

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.