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

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

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
RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

MayPowerBICarousel

Power BI Monthly Update - May 2024

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

LearnSurvey

Fabric certifications survey

Certification feedback opportunity for the community.