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

Grow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.

Reply
PaulF0901
Regular Visitor

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
Regular Visitor

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
Europe Fabric Conference

Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.