'Count the number of users who appear more than once in a Table (Power BI)

I am stuck at a query which seems simple but is a tricky one for me.

Suppose I have a Table which has user connection data.
enter image description here

My goal is to find the users who connected more than one time for a particular Time Frame (Day, Month, Year)

I have to show it in a trend chart like below, If I click on Year button the axis for the trend will change to Year and give me Year wise results. enter image description here

But I am not able to get the Dynamic count for the users having multiple Rows.
Basically I just want to get count of users who have connected more than one time on that Day, Month or Year.

I can't create a Calculated column to just get the count of duplicates because it will be static. I mean I'll just get the overall count of duplicates.

What I need is for eg If a user logs in on month of Jan twice and then once on Feb, He should be part of the total count of users for Jan but not for Feb.

I hope I was clear, please let me know if I need to elaborate something else.

Thanks in Advance
Best Regards,
Pratik



Sources

This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.

Source: Stack Overflow

Solution Source