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

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Helper I
Helper I

Count number of distinct occurences per user



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!


Community Support
Community Support

Hi @Slowik131 ,


Number of occurences = COUNTROWS('Table')




Best Regards,

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

Super User
Super User

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

Helpful resources

July 2024 Power BI Update

Power BI Monthly Update - July 2024

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

July Newsletter

Fabric Community Update - July 2024

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