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 🫡👍
RichFlorida's avatar
RichFlorida
Helper V
2 years ago

Hi Daniel29195 ,

 

Thank you for your post.

 

I tried it, it did not work.

 

Please note "Event Num" is datatype TEXT.

  • Daniel29195's avatar
    Daniel29195
    Community Champion
    2 years ago

    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 ?