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

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

Reply
PaulF0901
New Member

Perhaps a simple count for table rows

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. 

 

 

1 ACCEPTED SOLUTION
Ritaf1983
Super User
Super User

Hi @PaulF0901 
If I understood you correctly the measure is :

Objects # = COUNTROWS()
Ritaf1983_0-1707880494998.png

The needed visual is a matrix:

Ritaf1983_1-1707880552660.png

pbix is attached

If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly.

View solution in original post

3 REPLIES 3
PaulF0901
New Member

A million thankyou's for this, and for indulging a beginner. Your help is very much appreciated. 

Happy to help😊

Ritaf1983
Super User
Super User

Hi @PaulF0901 
If I understood you correctly the measure is :

Objects # = COUNTROWS()
Ritaf1983_0-1707880494998.png

The needed visual is a matrix:

Ritaf1983_1-1707880552660.png

pbix is attached

If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly.

Helpful resources

Announcements
LearnSurvey

Fabric certifications survey

Certification feedback opportunity for the community.

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

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

April Fabric Community Update

Fabric Community Update - April 2024

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