Replacing Column Totals in a Table visualization with Average

[jamieham]

I want to add a Table Visualization with numerous columns but want to replace the Totals row along the bottom with the Average for each column. Can this be done and if so how?

Thanks

[Anonymous · Accepted solution]

Hi @jamieham 

If you want to show average in Total in your Table visual, you can try average function in values.

If your table doesn't have multiple categorys, you can use average directly.

Result:

If your table has multiple categorys, you can add an index and set Don't summarize in index column

Result:

Best Regards,

Rico Zhou

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

[amitchandak]

@jamieham , Assume you have one group by (un summarized column) then

averageX(values(Table[row]), [measure])

or

averageX(summarize(Table,Table[row], Table[row2],"_1", [measure]),[_1])

Or use isinscope with measure and Avg Measure

https://www.kasperonbi.com/use-isinscope-to-get-the-right-hierarchy-level-in-dax/

if(isinscope(Table[row]) , [measure], [Avg Measure])