Is it possible to change the total Column in a table from Sum to average?

[Anonymous]

Hi,

as the titles says I am trying to change the total row in a table to show the average. Is this possible? See below, Column headers are week and row headers are individual products. The values are then the sold quantities (sum). 

Can this be done?

Thanks in advance.

[ribisht17 · Accepted solution]

@Anonymous 

Please check Solved: Show Average instead of Sum in TOTALS? - Microsoft Power BI Community

Regards,

Ritesh

Mark my post as a solution if it helped you| Munde and Kudis (Ladies and Gentlemen) I like your Kudos!! !!
My YT Channel Dancing With Data !! Connect on Linkedin !!Power BI for Tableau Users