Who Can Do That ?

Question

Question: How to Show Only the Total Average in a Power BI Matrix (Not for Each Month)?I am using a matrix visual in Power BI and want to calculate the average for my data, but I only want to display the total average, not the average for each month. However, the matrix is currently showing the average for all the individual months as well. How can I adjust the matrix to show only the total average?&nbsp;

bhanu_gautam · Answer

mianjalil239&nbsp;, Create a measure for Total Average
&nbsp;
Total Average = AVERAGEX(ALL('YourTable'), 'YourTable'[YourColumn])
&nbsp;
Add the newly created measure to the values section of your matrix visual.Adjust the Matrix Visual:
Remove the original column that shows the monthly averages from the values section.Ensure that only the "Total Average" measure is in the values section.Format the Matrix Visual:
Go to the "Format" pane of the matrix visual.Under "Subtotals," turn off the row and column subtotals if they are not needed.

mianjalil239 · Answer

Its not work I want Sum Of OT for all months and Total and avearge of Total guide me about this&nbsp;

mianjalil239 · Answer

&nbsp;

mianjalil239 · Answer

I want to put condiation format of aug&nbsp;

Forum Discussion

Who Can Do That ?

4 Replies