Calculation of the average by columns and rows and deviation

[Syndicate_Admin]

Good morning

I tell you, I have a table with a series of movements listed with date and user.

I would need to perform the following visualization through the BI, where on the one hand the sum of times that each user made that movement in that day appears, and then the averages of rows and columns. I would also like to get the % of each row (and column) with respect to the average of rows and columns.

I do not know very well how to do it in Power BI, and if the same situation would help me later to visualize and manipulate it in Excel.

Thanks in advance!

	Day 1	Day 2	Day 3	Day 4	Average User	% of average users
User 1	29	71	41	90
User 2	39	83	68	20
Daily average
% compared to the average of the days

[Syndicate_Admin]

I have found another example of what I am looking for in case it can help clarify:
https://stackoverflow.com/questions/64869614/how-to-show-avg-value-in-matrix-widget-along-with-total...

[Syndicate_Admin]

Thank you very much for the clarification!

What formulas should I use to show the averages, and in the other the deviation?

[lbendlin]

You can use implicit measures in the matrix visual or the equivalent DAX functions.

[lbendlin]

You can only have one set of row and column totals in a matrix visual.  You would need to use two copies of the same matrix visual, one set to show the averages, the other to show the deviation

or you can consider using custom visuals.