How to have different ways of aggregratings numbers in powerbi Tables

[GAPER]

As you can see the mean of 0 is .43. However, I want the 0 's mean to be the sum of the five individual numbers

(so roughly 0.45+0.51+.24+.49+.46) Is there a way to do that?

Thanks

[GAPER]

One more follow up - now the numbers look right for each inidividual row but not right for Total - Total is now the sum of the values (1.57+2.61+2.31+0.91+1.72) instead of the std / mean of all data points summed (. I am sorry that I can't upload the data. Sorry that I can't upload the data but the STDEV total should be close to 2.48 if i calculate on excel

[rajendraongole1 · Accepted solution]

Hi @GAPER  - you can create a measure to sum the values as follows with selected value function grouping =0

Mean_Adjusted =
IF(SELECTEDVALUE(Grouping) = 0,
SUMX(VALUES([Metric]), [Mean_Measure]),
[Mean_Measure]
)

Hope this helps, if any please share sample data or pbix by removing sensitive data . will check it from our end.

[GAPER]

You Are amazing Raj