12-20-2018 09:19 AM
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 )
12-20-2018 11:31 AM
See if my Matrix Measure Triple Threat Rock & Roll Quick Measure helps:
Did I answer your question? Mark my post as a solution!
Proud to be a Datanaut!
12-23-2018 09:29 PM
Could you please share a sample file to have a test if possible?
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.