https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Ayuda-para-crear-medida-filtro-propagado/m-p/4417013#M175396 <P><a href="javascript:void(0)" data-lia-user-mentions="" data-lia-user-uid="933626" data-lia-user-login="SaAzcona" class="lia-mention lia-mention-user">SaAzcona</a>&nbsp;, Try using</P> <P>&nbsp;</P> <P>Clients Maximum Month = <BR />VAR MaxMonth = <BR />CALCULATE(<BR />MAX(dim_Calendar[MonthNumber]),<BR />ALLSELECTED(dim_Calendar)<BR />)<BR />VAR MaxClients = <BR />CALCULATE(<BR />[Clients],<BR />dim_Calendar[MonthNumber] = MaxMonth,<BR />ALLSELECTED(dim_Calendar)<BR />)<BR />RETURN<BR />MaxClients</P> Wed, 19 Feb 2025 06:03:04 GMT bhanu_gautam 2025-02-19T06:03:04Z https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Ayuda-para-crear-medida-filtro-propagado/m-p/4416961#M175391 <P>Hola, saludos desde República Dominicana!</P><P>&nbsp;</P><P>Tengo una consulta de cómo crear una medida para obtener en mi modelo la cantidad de clientes del mes máximo propagado a todos los meses. Aquí dejo la data de ejemplo, en donde [Clientes] es una medida que suma los clientes, y la medida [Clientes Mes Máximo] es lo que debería tener como resultado:</P><P>&nbsp;</P><TABLE><TBODY><TR><TD>Año</TD><TD>Mes</TD><TD>Clase</TD><TD>[Clientes]</TD><TD>[Clientes Mes Máximo]</TD></TR><TR><TD>2024</TD><TD>7</TD><TD>A</TD><TD>299,670</TD><TD><STRONG>520,870</STRONG></TD></TR><TR><TD>2024</TD><TD>7</TD><TD>B</TD><TD>619,913</TD><TD><STRONG>494,458</STRONG></TD></TR><TR><TD>2024</TD><TD>7</TD><TD>C</TD><TD>231,127</TD><TD><STRONG>147,026</STRONG></TD></TR><TR><TD>2024</TD><TD>7</TD><TD>D</TD><TD>72,286</TD><TD><STRONG>72,436</STRONG></TD></TR><TR><TD>2024</TD><TD>8</TD><TD>A</TD><TD>248,411</TD><TD><STRONG>520,870</STRONG></TD></TR><TR><TD>2024</TD><TD>8</TD><TD>B</TD><TD>688,156</TD><TD><STRONG>494,458</STRONG></TD></TR><TR><TD>2024</TD><TD>8</TD><TD>C</TD><TD>211,726</TD><TD><STRONG>147,026</STRONG></TD></TR><TR><TD>2024</TD><TD>8</TD><TD>D</TD><TD>86,447</TD><TD><STRONG>72,436</STRONG></TD></TR><TR><TD>2024</TD><TD>9</TD><TD>A</TD><TD>352,726</TD><TD><STRONG>520,870</STRONG></TD></TR><TR><TD>2024</TD><TD>9</TD><TD>B</TD><TD>660,621</TD><TD><STRONG>494,458</STRONG></TD></TR><TR><TD>2024</TD><TD>9</TD><TD>C</TD><TD>155,889</TD><TD><STRONG>147,026</STRONG></TD></TR><TR><TD>2024</TD><TD>9</TD><TD>D</TD><TD>62,539</TD><TD><STRONG>72,436</STRONG></TD></TR><TR><TD>2024</TD><TD>10</TD><TD>A</TD><TD><STRONG>520,870</STRONG></TD><TD><STRONG>520,870</STRONG></TD></TR><TR><TD>2024</TD><TD>10</TD><TD>B</TD><TD><STRONG>494,458</STRONG></TD><TD><STRONG>494,458</STRONG></TD></TR><TR><TD>2024</TD><TD>10</TD><TD>C</TD><TD><STRONG>147,026</STRONG></TD><TD><STRONG>147,026</STRONG></TD></TR><TR><TD>2024</TD><TD>10</TD><TD>D</TD><TD><STRONG>72,436</STRONG></TD><TD><STRONG>72,436</STRONG></TD></TR></TBODY></TABLE><P>&nbsp;</P><P>En este ejemplo tengo una matriz que selecciona varios meses y me gustaría una medida que traiga los resultados del último mes del filtro externo. Hice una medida de prueba pero el resultado no propaga la clase:</P><DIV><DIV><DIV><DIV><SPAN>Test Clients =</SPAN></DIV><DIV><SPAN>CALCULATE</SPAN><SPAN>(</SPAN></DIV><DIV><SPAN>&nbsp; &nbsp; </SPAN><SPAN>SUMX</SPAN><SPAN>(</SPAN></DIV><DIV><SPAN>&nbsp; &nbsp; &nbsp; &nbsp; </SPAN><SPAN>VALUES</SPAN><SPAN>(</SPAN><SPAN>dim_Calendario</SPAN><SPAN>[Numero Mes]</SPAN><SPAN>),</SPAN></DIV><DIV><SPAN>&nbsp; &nbsp; &nbsp; &nbsp; </SPAN><SPAN>[Clientes]</SPAN></DIV><DIV><SPAN>&nbsp; &nbsp; ),</SPAN><SPAN>ALLSELECTED</SPAN><SPAN>(),</SPAN></DIV><DIV><SPAN>&nbsp; &nbsp; </SPAN><SPAN>dim_Calendario</SPAN><SPAN>[Numero Mes]</SPAN><SPAN> = </SPAN><SPAN>MONTH</SPAN><SPAN>(</SPAN><SPAN>MAX</SPAN><SPAN>(</SPAN><SPAN>dim_Calendario</SPAN><SPAN>[Date]</SPAN><SPAN>))</SPAN></DIV><DIV><SPAN>)</SPAN></DIV><DIV><SPAN>Aquí el resultado.</SPAN></DIV><DIV><img /><P>&nbsp;</P><P>Este es mi modelo:</P><img /><P>&nbsp;</P><P>¿Estoy obviando algún otro filtro?</P><P>&nbsp;</P><P>Muchas gracias de antemano por el soporte!</P></DIV></DIV></DIV></DIV> Wed, 19 Feb 2025 05:29:27 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Ayuda-para-crear-medida-filtro-propagado/m-p/4416961#M175391 SaAzcona 2025-02-19T05:29:27Z https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Ayuda-para-crear-medida-filtro-propagado/m-p/4417013#M175396 <P><a href="javascript:void(0)" data-lia-user-mentions="" data-lia-user-uid="933626" data-lia-user-login="SaAzcona" class="lia-mention lia-mention-user">SaAzcona</a>&nbsp;, Try using</P> <P>&nbsp;</P> <P>Clients Maximum Month = <BR />VAR MaxMonth = <BR />CALCULATE(<BR />MAX(dim_Calendar[MonthNumber]),<BR />ALLSELECTED(dim_Calendar)<BR />)<BR />VAR MaxClients = <BR />CALCULATE(<BR />[Clients],<BR />dim_Calendar[MonthNumber] = MaxMonth,<BR />ALLSELECTED(dim_Calendar)<BR />)<BR />RETURN<BR />MaxClients</P> Wed, 19 Feb 2025 06:03:04 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Ayuda-para-crear-medida-filtro-propagado/m-p/4417013#M175396 bhanu_gautam 2025-02-19T06:03:04Z https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Ayuda-para-crear-medida-filtro-propagado/m-p/4417931#M175419 <P>Thank you very much!! It worked just fine!</P> Wed, 19 Feb 2025 14:29:04 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Ayuda-para-crear-medida-filtro-propagado/m-p/4417931#M175419 SaAzcona 2025-02-19T14:29:04Z