Forum Discussion
Adding a Total row to a Table visual
Hello All,
I have the Tabel visual below (not a matrix).
- 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".
- 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!
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 🫡👍
6 Replies
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 helpbest regardsHi 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 ?
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
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 🫡👍
