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 ther...
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.

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.