Frequent Flyers

[James314]

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=11465...

[v-cgao-msft · Accepted solution]

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 Team

If 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

[Idrissshatila]

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-...

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/1447...

[James314]

Thanks, I've added a link to Google Drive.