How to show average in total of column which is aggregated by sum

[Kandarp]

I am trying to show an average in total. That column has aggregate by SUM. Please see below example (screenshot attached). I have done some research but I am not sure is it really achievable or not. I need some guidance. Thank you.

[Kandarp]

Hi @MahyarTF 

Thanks a lot. This works like a charm. 

[MahyarTF · Accepted solution]

Hi

Create the measure as below and use it in your visual against the original Sales amount :

Average of salesAmnt = DIVIDE(sum(Sheet176[Sales Amount]), DISTINCTCOUNT(Sheet176[Product Name])))

The right one is used the new measure

Appreciate your Kudos

[Kandarp]

Hi @MahyarTF ,

Is there anything we can do to improve the performance here? Above measures slows down the peroformance in direct query mode. I have 14-15 columns in a table. I really appreciate any guidance here. 

[MahyarTF]

Hi @Kandarp ,

Not sure what the solution is ?

I usually use the performance Analyzer to trace and improve the visuals performance.