get rid of column repetition in matrix

[Anonymous]

Dear Community, 
please help me, 
I wanted to take average of 1,2,3,4,5 and show it in one column,
I used measure formula to calculate average: 

MeasureAvg = CALCULATE(AVERAGE('Table'[X]), ALLEXCEPT('Table', 'wash Table1'[Cl], 'Table1'[S], 'Table1'[L]))
Now I want to know how can i get rid of multiple measure, as I just want to have one coulmn at the end which shows average per row, not repetition of it per column.
Thanks in advance

[Anonymous]

Hi  @Anonymous ,

You can put the Y column in value and select AVG to get the average directly.

Here are the related links for your reference:：

https://community.powerbi.com/t5/Desktop/Show-percentage-on-matrix/td-p/141705

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.

[amitchandak]

@Anonymous , For that you need hybrid table, which not supported. Refer to alternate and Idea to vote for

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