Forum Discussion
Frequent Flyers
Hi all, been working on this for a while and I just can't crack it.
I have a table with User ID, Date of Visit and Location along with other attributes (age, gender, etc.). The data model includes a working date table.
I'm looking to create a visual that will list for each Location, how many users have had more than 5 visits in the previous 12 months, potentially with a drill down to list the users under each location.
I won't list the things I've tried to avoid clogging up the post but any help would be really appreciated. Here's a link to a sample dataset: https://docs.google.com/spreadsheets/d/1-zZ8BWVyxwdkZSepFNLlWL31AUee_heZ/edit?usp=sharing&ouid=114655477604417075672&rtpof=true&sd=true
Hi James314 ,
Please try like:MEASURE = COUNTROWS ( FILTER ( SUMMARIZE ( 'Table', 'Table'[Location], 'Table'[User ID], "@count", COUNT ( 'Table'[User ID] ) ), [@count] > 5 ) )Best Regards,
Gao
Community Support TeamIf there is any post helps, then please consider Accept it as the solution to help the other members find it more quickly.
If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!How to get your questions answered quickly -- How to provide sample data in the Power BI Forum -- China Power BI User Group
3 Replies
Hi James314 ,
Please try like:MEASURE = COUNTROWS ( FILTER ( SUMMARIZE ( 'Table', 'Table'[Location], 'Table'[User ID], "@count", COUNT ( 'Table'[User ID] ) ), [@count] > 5 ) )Best Regards,
Gao
Community Support TeamIf there is any post helps, then please consider Accept it as the solution to help the other members find it more quickly.
If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!How to get your questions answered quickly -- How to provide sample data in the Power BI Forum -- China Power BI User Group
HEllO James314 ,
Please share sample data in a usable format (not screenshots) that fully addresses your issue or question.Avoid including sensitive info or unrelated content. Need help uploading data? Visit https://community.fabric.microsoft.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-Forum/ba-p/963216
Show what you expect based on the provided data.
For faster answers, see https://community.fabric.microsoft.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447523#M607150
Thanks, I've added a link to Google Drive.
