https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Suma-filtrada/m-p/2816326#M89321 <P><FONT>Hi，&nbsp;<a href="javascript:void(0)" data-lia-user-mentions="" data-lia-user-uid="363432" data-lia-user-login="MONTENEGRO" class="lia-mention lia-mention-user">MONTENEGRO</a></FONT>&nbsp;</P> <P>If there is no relationship created between your calendar table and Resultados Operaciones table, you can try to calculate&nbsp;total budget with measures like the following.</P> <P>&nbsp;</P> <LI-CODE lang="markup">Presupuesto anual = CALCULATE ( SUM ( 'Resultados Operaciones'[Presupuesto] ), FILTER ( 'Resultados Operaciones', 'Resultados Operaciones'[Fecha] IN VALUES ( Calendario[Fecha] ) ) )</LI-CODE> <P>&nbsp;</P> <LI-CODE lang="markup">Presupuesto anual2 = SUMX(ALLEXCEPT(Calendario,Calendario[Periodo]),[Presupuesto anual])</LI-CODE> <P>Hope this could help.</P> <P>&nbsp;</P> <P><FONT>Best Regards,<BR />Community Support Team _ Eason</FONT></P> Tue, 04 Oct 2022 09:03:53 GMT v-easonf-msft 2022-10-04T09:03:53Z https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Suma-filtrada/m-p/2814839#M89237 <P>Necesito sumar los el presupuesto total del periodo, pero que solo respete el segmentador periodo e ignore los demas segmentadores como el mes.</P><P><img /></P><P>&nbsp;</P><P>Campos de tabla calendario</P><P><img /></P><P>&nbsp;</P> Mon, 03 Oct 2022 19:04:40 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Suma-filtrada/m-p/2814839#M89237 MONTENEGRO 2022-10-03T19:04:40Z https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Suma-filtrada/m-p/2816326#M89321 <P><FONT>Hi，&nbsp;<a href="javascript:void(0)" data-lia-user-mentions="" data-lia-user-uid="363432" data-lia-user-login="MONTENEGRO" class="lia-mention lia-mention-user">MONTENEGRO</a></FONT>&nbsp;</P> <P>If there is no relationship created between your calendar table and Resultados Operaciones table, you can try to calculate&nbsp;total budget with measures like the following.</P> <P>&nbsp;</P> <LI-CODE lang="markup">Presupuesto anual = CALCULATE ( SUM ( 'Resultados Operaciones'[Presupuesto] ), FILTER ( 'Resultados Operaciones', 'Resultados Operaciones'[Fecha] IN VALUES ( Calendario[Fecha] ) ) )</LI-CODE> <P>&nbsp;</P> <LI-CODE lang="markup">Presupuesto anual2 = SUMX(ALLEXCEPT(Calendario,Calendario[Periodo]),[Presupuesto anual])</LI-CODE> <P>Hope this could help.</P> <P>&nbsp;</P> <P><FONT>Best Regards,<BR />Community Support Team _ Eason</FONT></P> Tue, 04 Oct 2022 09:03:53 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Suma-filtrada/m-p/2816326#M89321 v-easonf-msft 2022-10-04T09:03:53Z