Get certified for free when you join Fabric Data Days 2026 and dive into Fabric, Power BI, SQL, AI, and other essential data skills.
Join nowJuly 7 - July 17 | Round 2 of the Power BI Dataviz World Championships. Don't miss your chance! Learn more
It's always a little daunting asking what is probably considered a simple question but here goes.
I have a table of users of a product. The table is similar to this:
Date/Time User name Event ObjectType
Feb 1 John CREATED DOCUMENT
Feb 1 John CREATED DOCUMENT
Feb 2 Elaine DELETED DOCUMENT
Feb 3 John CREATED FOLDER
Feb 4 John DELETED DOCUMENT
I have a slicer (Activities) to which I have added the EVENT and OBJECTTYPE rows. I have another slicer with the USERNAMES.
When I select a username, the Activities slicer shows the following, tailored to whichever username I select:
CREATED
DOCUMENT
FOLDER
DELETED
DOCUMENT
How can I get it to add a count to the end? For example, if I select John, I would get:
CREATED
DOCUMENT (2)
FOLDER (1)
DELETED
DOCUMENT (1)
I imagined I could just count up the number of rows that go to make up that output but I have no idea how. Again, apologies if this is incredibly obvious.
Solved! Go to Solution.
Hi @PaulF0901
If I understood you correctly the measure is :
The needed visual is a matrix:
pbix is attached
If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly.
A million thankyou's for this, and for indulging a beginner. Your help is very much appreciated.
Happy to help😊
Hi @PaulF0901
If I understood you correctly the measure is :
The needed visual is a matrix:
pbix is attached
If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly.
Join us in Barcelona for FabCon and SQLCon, the Fabric, Power BI, SQL, and AI community event. Save €200 with code FABCMTY200.
Join Fabric Data Days 2026: 60 days of free live/on-demand sessions, challenges, study groups, and certification opportunities.
| User | Count |
|---|---|
| 63 | |
| 41 | |
| 39 | |
| 39 | |
| 39 |