Count the total number of visitors that have visited 4 or more times

[MattSwan]

I'm trying to write a measure that will display the total number of visitors that have visited the site 4 or more times.

Each visit is one row of the table. I've managed to identify the records with Measure = COUNTROWS(Visitors)>4, but I'm a bit stuck on where to go next.

Any suggestions?

[Jihwan_Kim · Accepted solution]

Hi,

I tried to create a sample pbix file like below.

Please check the below picture and the attached pbix file.

I hope the below can provide some ideas on how to create a solution for your datamodel.

Visitors count more than 4 visits: =
COUNTROWS ( FILTER ( DISTINCT ( Visit[Visitor ID] ), [Visit count:] > 4 ) )

[MattSwan]

Jihwan! Thank you. Worked a charm. The PBIX was very helpful too as I didn't see you'd used two measures.

Thanks Again!