Forum Discussion

RichFlorida's avatar
RichFlorida
Helper V
2 years ago
Solved

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...
Need Help
  • Daniel29195's avatar
    Daniel29195
    2 years ago

    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 🫡👍
Daniel29195's avatar
Daniel29195
Community Champion
2 years ago

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