Forum Discussion
Helper IIReplacing Column Totals in a Table visualization with Average
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
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.
2 Replies
- amitchandak
Super User
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])
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.
