Forum Discussion

COMtrac's avatar
COMtrac
Advocate I
9 years ago

Adding a row count to a visual table

I was wondering whether there is an easy way to add a count to a column in a visual table in PowerBI Desktop.  The column in the table has text entries and basically I just want to show the total of ...
Need Help
Baskar's avatar
Baskar
Resident Rockstar
9 years ago

Simple drag any column at last and choose aggeregation is Count.

 

Look the image 

  • COMtrac's avatar
    COMtrac
    Advocate I
    9 years ago

    Hi Baskar

     

    I was trying to avoid having to add another calcuated column (such as the count column).  Ideally using your image I wantt o count to appear under the Workitam ID rather then having to add another column called Workitem ID Count.

     

    I hope that make sense

    • Baskar's avatar
      Baskar
      Resident Rockstar
      9 years ago

      COMtrac

      Ya i got it.

       

      here i have to sorry , because presnetly in power bi we can't get the total value or count without any measure in your table.

       

      Sorry :-(

       

      • COMtrac's avatar
        COMtrac
        Advocate I
        9 years ago

        Thanks for the response anyway

         

        Regards

         

        Craig

    • v-ljerr-msft's avatar
      v-ljerr-msft
      Microsoft Employee
      9 years ago

      Hi COMtrac,

      I was trying to avoid having to add another calcuated column (such as the count column).  Ideally using your image I wantt o count to appear under the Workitam ID rather then having to add another column called Workitem ID Count.

      I don't think it is possible to do it within a Table visual in Power BI currently. You can submit your requirements on Power BI Ideas and vote it up to improve Power BI.:smileyhappy:

       

      Regards

      • COMtrac's avatar
        COMtrac
        Advocate I
        9 years ago

        Cheers

         

        Thanks

  • Anonymous's avatar
    Anonymous
    Not applicable
    8 years ago

    It seems simple and elegant way to count it.