Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.

Reply
James314
Frequent Visitor

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

1 ACCEPTED SOLUTION
v-cgao-msft
Community Support
Community Support

Hi @James314 ,

Please try like:

MEASURE = 
COUNTROWS (
    FILTER (
        SUMMARIZE (
            'Table',
            'Table'[Location],
            'Table'[User ID],
            "@count", COUNT ( 'Table'[User ID] )
        ),
        [@count] > 5
    )
)

vcgaomsft_0-1707981697864.png

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

View solution in original post

3 REPLIES 3
v-cgao-msft
Community Support
Community Support

Hi @James314 ,

Please try like:

MEASURE = 
COUNTROWS (
    FILTER (
        SUMMARIZE (
            'Table',
            'Table'[Location],
            'Table'[User ID],
            "@count", COUNT ( 'Table'[User ID] )
        ),
        [@count] > 5
    )
)

vcgaomsft_0-1707981697864.png

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
Super User
Super User

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



Did I answer your question? Mark my post as a solution! Appreciate your Kudos
Follow me on LinkedIn linkedIn
Vote for my Community Mobile App Idea

Proud to be a Super User!




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

Helpful resources

Announcements
Microsoft Fabric Learn Together

Microsoft Fabric Learn Together

Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

Check out the April 2024 Power BI update to learn about new features.

April Fabric Community Update

Fabric Community Update - April 2024

Find out what's new and trending in the Fabric Community.