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
MONTENEGRO
Frequent Visitor

Suma filtrada

Necesito sumar los el presupuesto total del periodo, pero que solo respete el segmentador periodo e ignore los demas segmentadores como el mes.

MONTENEGRO_0-1664823730663.png

 

Campos de tabla calendario

MONTENEGRO_1-1664823859687.png

 

1 ACCEPTED SOLUTION
v-easonf-msft
Community Support
Community Support

Hi, @MONTENEGRO 

If there is no relationship created between your calendar table and Resultados Operaciones table, you can try to calculate total budget with measures like the following.

 

Presupuesto anual =
CALCULATE (
    SUM ( 'Resultados Operaciones'[Presupuesto] ),
    FILTER (
        'Resultados Operaciones',
        'Resultados Operaciones'[Fecha] IN VALUES ( Calendario[Fecha] )
    )
)

 

Presupuesto anual2 = SUMX(ALLEXCEPT(Calendario,Calendario[Periodo]),[Presupuesto anual])

Hope this could help.

 

Best Regards,
Community Support Team _ Eason

View solution in original post

1 REPLY 1
v-easonf-msft
Community Support
Community Support

Hi, @MONTENEGRO 

If there is no relationship created between your calendar table and Resultados Operaciones table, you can try to calculate total budget with measures like the following.

 

Presupuesto anual =
CALCULATE (
    SUM ( 'Resultados Operaciones'[Presupuesto] ),
    FILTER (
        'Resultados Operaciones',
        'Resultados Operaciones'[Fecha] IN VALUES ( Calendario[Fecha] )
    )
)

 

Presupuesto anual2 = SUMX(ALLEXCEPT(Calendario,Calendario[Periodo]),[Presupuesto anual])

Hope this could help.

 

Best Regards,
Community Support Team _ Eason

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.

Top Solution Authors