How to count simultaneous logins

[Pelas68]

I would like to have some help with my issue. I would like to count simultaneous logins (logins that have happened almost simultaneously) to calculate actual logins. I have a table like below. I there any solutions with DAX or some other solutions?

[Pelas68]

Hi,

Sorry I don´t understand that step two, should I create new table (because I don´t recognize that word anithort 🙃) and then create the slicer based colum to that table?

Best regards,

Petri

[Anonymous]

Hi @Pelas68 ,

Yes, you can create a new Table 2 with Logins/months column. Then put it in the silcer.

How to Get Your Question Answered Quickly 

If it does not help, please provide more details with your desired output and pbix file without privacy information (or some sample data) .

Best Regards
Community Support Team _ Polly

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Anonymous · Accepted solution]

Hi @Pelas68 ,

Please have a try.

1. Create a calculate column to achieve the month:

Month =
MONTH ( Table[created_at] )

2. Create a slicer based on Logins/months column in anithort table.

3. Create a calculate column to achieve the login times per month per id using DAX below:

count =
CALCULATE ( COUNT ( Table[id] ), ALLEXCEPT ( Table, Table[Month], Table[id] ) )

4. Create a measure to achieve the login count:

Users =
IF (
    Table2[Logins/months] <> ">10",
    CALCULATE (
        DISTINCTCOUNT ( Table[id] ),
        FILTER ( Table, Table[count] = SELECTEDVALUE ( Table2[Logins/month] ) )
    ),
    CALCULATE ( DISTINCTCOUNT ( Table[id] ), FILTER ( Table, Table[count] >= 10 ) )
)

5. Drag measure 'Users' and the Logins/month column to the table visual.

How to Get Your Question Answered Quickly 

If it does not help, please provide more details with your desired output and pbix file without privacy information (or some sample data) .

Best Regards
Community Support Team _ Polly

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.