Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
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 the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
User | Count |
---|---|
87 | |
84 | |
68 | |
64 | |
63 |
User | Count |
---|---|
208 | |
120 | |
113 | |
79 | |
72 |