Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

Adding A Total Row to Table with Calculated Columns

Hi All!

 

I have a table where I want to show totals for each column, but it seems the Total option only works for non-calculated columns. The only thing I can think would be to created Measurements and add them as rows.

 

Any help would be much appreciated, thanks!

 

 

Need Help
  • v-frfei-msft's avatar
    v-frfei-msft
    7 years ago

    Hi Anonymous,

     

    In my table visual, i can get all the sum total of my columns once I enbale the Totals option in Format pane. What is your datastruct or you add the measures in your visual? Could you please share your pbix to me to have a check?

     

     

    Regards,

    Frank

2 Replies

  • v-frfei-msft's avatar
    v-frfei-msft
    Community Support
    7 years ago

    Hi Anonymous,

     

    In my table visual, i can get all the sum total of my columns once I enbale the Totals option in Format pane. What is your datastruct or you add the measures in your visual? Could you please share your pbix to me to have a check?

     

     

    Regards,

    Frank

    • v-frfei-msft's avatar
      v-frfei-msft
      Community Support
      7 years ago

      Hi Anonymous ,

       

      Does that make sense? If so, kindly mark my answer as the solution to close the case please. Thanks in advance.

       

      Regards,
      Frank