cancel
Showing results for
Did you mean:
Highlighted
Frequent Visitor

## Change Matrix Grand total of one measure from sum to average

Hello
I have the following Matrix

each row come from a different measure. I need to change the grand total of the third row from SUM to Average, so from 100% to 91%, The measure of the third row is:

```% este Mes =
VAR m = CALCULATE( MAX( Ejemplo[Mes] ); ALLSELECTED() )   //Select the number of the month selected in the slicer
RETURN IF(                                                 // if the % is bigger than 100% just show 100%, if not show the real %
[Realizadas a la Fecha]/FIXED([Metas 2018]* m / 12;0;1)>1;
1;
[Realizadas a la Fecha]/FIXED([Metas 2018]* m / 12;0;1)   // Calculation of the %, using the numbers from the first row of the matrix ([Metas 2018]), the second row ([Realizadas a la Fecha]) and Variable m that is the selected month in the slicer of the page
)```

Thanks

2 REPLIES 2
Super User IV

## Re: Change Matrix Grand total of one measure from sum to average

See if my Matrix Measure Triple Threat Rock & Roll Quick Measure helps:

https://community.powerbi.com/t5/Quick-Measures-Gallery/Matrix-Measure-Total-Triple-Threat-Rock-amp-...

---------------------------------------

Putting square pegs in round holes since 1972.

##### I have a NEW book! DAX Cookbook from Packt
Over 120 DAX Recipes!

Proud to be a Datanaut!

Microsoft

## Re: Change Matrix Grand total of one measure from sum to average

Could you please share a sample file to have a test if possible?

Regards,

Daniel He

Community Support Team _ Daniel He
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Announcements

#### ‘Better Together’ T-Shirt Contest – Winner Announced!

And the winner is...

#### Announcing the New Spanish Forum

Do you need help in Spanish? Check out our new Spanish community section.

#### April 2020 Community Highlights

Info on our Super Users, MBAS content and badges, and updates to our support articles. - Read the full Community Highlights.

#### MBAS Gallery 2020

Watch Microsoft Business Applications Summit sessions on-demand.

Top Solution Authors
Top Kudoed Authors