Forum Discussion

dinomaster's avatar
dinomaster
Frequent Visitor
9 years ago
Solved

Average column

 

Hi,

 

I have this table and I'd like to add a column similar to the total column but with the average.

 

When I try do it, a column with the average appears also in each month. 

 

My question is if it's possible to have just one column with the annual average?

 

Thanks

Need Help
  • v-sihou-msft's avatar
    v-sihou-msft
    9 years ago

    dinomaster

     

    In Power BI Desktop, we can change the aggregation type of the field into "Average". It will be applied onto Grand Total row/column as well.

     

     

    But we can only keep on Total row/column in a visual. It's not supported to add one more "Grand Total" row/column manually.

     

    Regards,

     

4 Replies

  • v-sihou-msft's avatar
    v-sihou-msft
    Icon for Microsoft Employee rankMicrosoft Employee
    9 years ago

    dinomaster

     

    In Power BI Desktop, we can change the aggregation type of the field into "Average". It will be applied onto Grand Total row/column as well.

     

     

    But we can only keep on Total row/column in a visual. It's not supported to add one more "Grand Total" row/column manually.

     

    Regards,

     

    • wouldbenerd's avatar
      wouldbenerd
      Regular Visitor
      9 years ago

      This menu seems to be no longer available? It Isn't appearing in my Power BI Desktop Version: 2.48.4792.481 64-bit (juli 2017)

  • Sean's avatar
    Sean
    Icon for Community Champion rankCommunity Champion
    9 years ago

    Not in the same Visual.

     

    Copy ( CTRL+C ) the Matrix - paste it ( CTRL+V ) on the right side of the current

     

    get rid of the Month field - and change to your Average Measure!

     

    Hope this helps! :smileyhappy:

    • CahabaData's avatar
      CahabaData
      Icon for Memorable Member rankMemorable Member
      9 years ago

      how about adding it at the table level as a calculated column?