Adding a Total row to a Table visual

[RichFlorida]

Hello All,

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

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!

[RichFlorida]

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

[Daniel29195 · Accepted solution]

@RichFlorida 

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 🫡👍

[RichFlorida]

Thanks you @Daniel29195 

This solution works and is greatly appreciated.

.

[RichFlorida]

Hi @Daniel29195 ,

Thank you for your post.

I tried it, it did not work.

Please note "Event Num" is datatype TEXT.

[Daniel29195]

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]

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 : 

Measure 13 =

if(

    ISFILTERED('Table (17)'[Date/Time]),MAX('Table (17)'[Event Num]), countrows('Table (17)'))

hope this help 

best regards