Fabric is Generally Available. Browse Fabric Presentations. Work
towards your Fabric certification with the Cloud Skills Challenge.
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.
Go to Solution.
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 ) )
If this post helps, then please consider accepting it as the solution to help other members find it faster, and give a big thumbs up.
View solution in original post
Jihwan! Thank you. Worked a charm. The PBIX was very helpful too as I didn't see you'd used two measures.
Check out the November 2023 Power BI update to learn about new features.
130+ sessions, 130+ speakers, Product managers, MVPs, and experts. All about Power BI and Fabric. Attend online or watch the recordings.