Column subtotal sum row subtotal average

[alexbalazsalex]

Dear All,

I would need you support for the below issue :

Basically the column subtotals are correct showing the sum of each row ... but for the row subtotal i would like average  (at the moment showing sum also there)...

IS that possible?

Many Thanks,

Alex

[v-xuding-msft · Accepted solution]

Hi @alexbalazsalex ,

You could create a measure with the functions of AVERAGEX and VALUES to implement it.

Here is my sample. Please reference it to modify yours.

Total sales = CALCULATE(SUM('Table'[Sales]))

Avg = AVERAGEX(VALUES('Table'[Product]),[Total sales])

Best Regards,

Xue Ding

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

[alexbalazsalex]

Many Thanks @v-xuding-msft 

Sometimes we tend to over complicate some things in our head .... very usefull & Gratefull for your feedback

Alex

[alexbalazsalex]

sorry just a clarification as i made a mistake ... i would want column subtotal as average and row subtotal leave as it is as sum.

Thanks

[amitchandak]

@alexbalazsalex ,

Share Data in table format with expected output and mark me @