Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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
Hi @rodfernandez,
Could you please share a sample file to have a test if possible?
Regards,
Daniel He
See if my Matrix Measure Triple Threat Rock & Roll Quick Measure helps:
User | Count |
---|---|
128 | |
109 | |
100 | |
65 | |
62 |
User | Count |
---|---|
137 | |
115 | |
102 | |
71 | |
61 |