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

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.

Reply
RichFlorida
Helper V
Helper V

Adding a Total row to a Table visual

Hello All,

 

I have the Tabel visual below (not a matrix).

 

RichFlorida_2-1705690188200.png

 

 

  1. I need to add a TOTAL row at the bottom that displays the total number of rows, or more accuratly, the total number of "Event Numbers".
  2. I would also like that total to be displayed at the bottom of the Event Num column.

 

Any idea how to do this using a Table Visual (not a Matrix).

 

Thanks!

 

1 ACCEPTED SOLUTION

@RichFlorida 

Daniel29195_0-1705962770788.png

you need to create a measure . and drag the measure into the table . 

measure =
if(
    ISFILTERED('data'[Date/Time]),MAX('data'[Event Num]), countrows('data'))
 
 
If my response has successfully addressed your issue kindly consider marking it as the accepted solution! This will help others find it quickly. Dont forget to hit that  thumbs up button 🫡👍

View solution in original post

6 REPLIES 6
RichFlorida
Helper V
Helper V

Hi @Daniel29195 

 

Below is  a link to the report. Please let me know if you can get a total displayed under the Event Num column.

 

Thanks!

 

 

https://drive.google.com/file/d/1lgMMFsAhCgGoKBmmzLdF_m1h2ehOiWQu/view?usp=sharing

 

@RichFlorida 

Daniel29195_0-1705962770788.png

you need to create a measure . and drag the measure into the table . 

measure =
if(
    ISFILTERED('data'[Date/Time]),MAX('data'[Event Num]), countrows('data'))
 
 
If my response has successfully addressed your issue kindly consider marking it as the accepted solution! This will help others find it quickly. Dont forget to hit that  thumbs up button 🫡👍

Thanks you @Daniel29195 

 

This solution works and is greatly appreciated.

.

RichFlorida
Helper V
Helper V

Hi @Daniel29195 ,

 

Thank you for your post.

 

I tried it, it did not work.

 

Please note "Event Num" is datatype TEXT.

hello @RichFlorida , 

is it possible that you can share the power bi file via google drive or any cloud storage so that i can take a look ? 

 

 

Daniel29195
Super User
Super User

Hello @RichFlorida 

 

if the relation between event and datetime is 1 to  1  ( which mean, if for each date/time, you have 1 and only one  event , you can something like this : 

Daniel29195_0-1705705333298.png

Measure 13 =
if(
    ISFILTERED('Table (17)'[Date/Time]),MAX('Table (17)'[Event Num]), countrows('Table (17)'))
 
 
 
 
hope this help 
 
best regards

Helpful resources

Announcements
July PBI25 Carousel

Power BI Monthly Update - July 2025

Check out the July 2025 Power BI update to learn about new features.

Join our Fabric User Panel

Join our Fabric User Panel

This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.

June 2025 community update carousel

Fabric Community Update - June 2025

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