Forum Discussion

Pelas68's avatar
Pelas68
Frequent Visitor
3 years ago
Solved

How to count simultaneous logins

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?

 

 

Need Help
  • Anonymous's avatar
    Anonymous
    3 years ago

    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.

3 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    3 years ago

    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.

  • Pelas68's avatar
    Pelas68
    Frequent Visitor
    3 years ago

    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's avatar
      Anonymous
      Not applicable
      3 years ago

      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.