Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
rodfernandez
Helper I
Helper I

Change Matrix Grand total of one measure from sum to average

Hello
I have the following Matrix
 Sin título.png

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
v-danhe-msft
Employee
Employee

Hi @rodfernandez,

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.
Greg_Deckler
Super User
Super User

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-...


@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!:
Mastering Power BI 2nd Edition

DAX is easy, CALCULATE makes DAX hard...

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.