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

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