count of repeated users

[suji]

Hi Frnz,

I am new to Power BI. I have below req in my project.

Need to show the total count of users, count of distinct users , and count of repeated users for the day.

ID Frame        Date                              UserName                

1                     7/1/2016 330 PM         Suresh                   

2                     7/1/2016 330 PM         John3

3                     7/1/2016 337 PM         Mike     

4                     7/1/2016 350 PM         Suresh 

5                     7/1/2016 351 PM         Mike     

6                     7/1/2016 358 PM         Mike     

I am able to get Total count and -6, distinct count -3.  But i need to get the count of repeated users -2  ( Suresh and Mike)

This repeated user count i need to show in a label

Thanks in advance.

Regards,

Suresh Peddirsi.

[suji]

I am new to Power BI. I have below req in my project.

Need to show the total count of users, count of distinct users , and count of repeated users for the day.

ID Frame        Date                              UserName                

1                     7/1/2016 330 PM         Suresh                   

2                     7/1/2016 330 PM         John3

3                     7/1/2016 337 PM         Mike     

4                     7/1/2016 350 PM         Suresh 

5                     7/1/2016 351 PM         Mike     

6                     7/1/2016 358 PM         Mike     

I am able to get Total count and -6, distinct count -3.  But i need to get the count of repeated users -2  ( Suresh and Mike)

This repeated user count i need to show in a label

Thanks in advance.

Regards,

Suresh Peddirsi.

[BhaveshPatel]

You can use a measure like this:

RepeatedCountsSuresh:=CALCULATE(COUNTA(MyTable[User Name]),MyTable[User Name]="Suresh")

Similarly you can count Mike as well.

or you can use ALLSELECTED where on selecting slicers, it will show count of particular username.

=CALCULATE(COUNTA(MyTable[User Name]), ALLSELECTED(MyTable[User Name]))

[Thiyags]

You can create a measure

Repeated Users=CountRows(MyTable).

Then add the user name and the measure into the rows and see the results

[suji]

Hi Bhiswas and Thiyags,

Thanks for your quick response.

My result should not be on selection based. I jst need to show the repeated user count on a label.

if the user record is inserted more then two times a day, i need to show that person as repeated user.

if i have total 5 records in the table, in that user1 repeated 2 times, user2 repeated 2 times and user3 is only one time (total 5)

I have to show repeated user count, that is 2 ( as only 2 users are recorded more then 2 times)

[Thiyags · Accepted solution]

Hi,

You hv to create 2 measures. Sheet12 is my Table in the below formula

1. UsersLevelCount= CALCULATE(CountRows(Sheet12),ALLEXCEPT(Sheet12,Sheet12[UserName ]))

2. Repeat Users=CALCULATE(DISTINCTCOUNT(Sheet12[UserName ]),FILTER(Sheet12,Sheet12[Measure]>1))