Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It 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.
User | Count |
---|---|
99 | |
86 | |
80 | |
76 | |
71 |
User | Count |
---|---|
112 | |
105 | |
96 | |
74 | |
66 |