Add new column with average for each row of the product Group

[Anonymous]

I would like to add a new column called Average and displaying the average for every row ( for example it should be ~ 99.193 ((111.640 + 28.952 + 84.856 + 171.326) /4) for the row Amarilla row and so on for the other element). Here I have used a matrix table but maybe is there an easier way to do that and have such table. 

[Anonymous]

Hi  @Anonymous ,

It is not possible to add a column directly behind as Average, and it will be displayed in each column:

Here are the steps you can follow：

1. Select Average

2. Select Subtotals, find Font color, adjust the font color to the same as the background color, hide it, only the required data will be displayed

Best Regards,

Liu Yang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Anonymous]

你好刘洋，我有相似的问题。你的意思是说无法在数据上加一行，只能在报告那里添加平均值吗？谢谢

[amitchandak]

@Anonymous ,

if you are looking for a Hybrid display with Matrix Column and measure
https://community.powerbi.com/t5/Community-Blog/Creating-a-custom-or-hybrid-matrix-in-PowerBI/ba-p/1354591
https://community.powerbi.com/t5/Quick-Measures-Gallery/The-New-Hotness-Custom-Matrix-Hierarchy/m-p/963588#M428

vote for Hybrid Table
https://ideas.powerbi.com/ideas/idea/?ideaid=9bc32b23-1eb1-4e74-8b34-349887b37ebc