Count number of distinct occurences per user

Anonymous · ‎11-02-2023

Hi,

I'm trying to count the number of occurences of the below "number of sessions per user"

So what I need is distinct values of number of sessions and then count how many times they occur. So basically this should be the result:

I know I can summarize it in a table and then count it, but it is very space consuming, so is there a way to do it via measures?

Thank you!

Anonymous · ‎11-06-2023

Hi @Anonymous ,

Number of occurences = COUNTROWS('Table')

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

parry2k · ‎11-02-2023

@Anonymous pretty much you need a disconnected table to make it work, here are couple of video which will help you to develop the solution:

Mastering Disconnected Tables - Use measures in slicers in Power BI | PeryTUS - Power BI How To - Yo...

Mastering Disconnected Tables -Solve Complex Problems in Power BI | PeryTUS - Power BI How To - YouT...

Subscribe to the @PowerBIHowTo YT channel for an upcoming video on List and Record functions in Power Query!!

Learn Power BI and Fabric - subscribe to our YT channel - Click here: @PowerBIHowTo

If my solution proved useful, I'd be delighted to receive Kudos. When you put effort into asking a question, it's equally thoughtful to acknowledge and give Kudos to the individual who helped you solve the problem. It's a small gesture that shows appreciation and encouragement! ❤

Did I answer your question? Mark my post as a solution. Proud to be a Super User! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.