Advance your Data & AI career with 50 days of live learning, dataviz contests, hands-on challenges, study groups & certifications and more!
Get registeredGet Fabric Certified for FREE during Fabric Data Days. Don't miss your chance! Request now
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.
Advance your Data & AI career with 50 days of live learning, contests, hands-on challenges, study groups & certifications and more!
Check out the October 2025 Power BI update to learn about new features.