Get number of distinct users above count

[Anonymous]

Hi,

I'm new to Power BI and have a table with documents, users and timestamp. 
I have created two count measures, distinct and just count. Now I would like to add a third measure that shows how many users have more than 10 rows for each document and show that in a table.

Not sure how to get this measure to work.

Thanks so much!

[Anonymous]

@themistoklis 
No, I do not have that. Each row has the document name, user and a timestamp. 
Might have to get the count of each document? But with a table visual I can easy show documents and the count of unique uesers and total rows for each document. Just would like to add another measure that shows how many unique users have a count of more than 10.

Thank!

[themistoklis · Accepted solution]

@Anonymous 

Create a summarize table (not measure or column)

Table = SUMMARIZE(Sheet1, Sheet1[Document], Sheet1[User], "No of Rows", COUNT(Sheet1[Document]))

Then on this table write a count formula:

No of Users = CALCULATE(DISTINCTCOUNT('Table'[User]),'Table'[No of Rows]>2)

See attached file.

[themistoklis]

Helo @Anonymous 

Is there a field that shows the number of rows per document?