Forum Discussion
RichFlorida
2 years agoHelper V
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 "E...
- 2 years ago
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
2 years agoHelper 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
Daniel29195
2 years agoCommunity Champion
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 🫡👍
- RichFlorida2 years agoHelper V