The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredCompete to become Power BI Data Viz World Champion! First round ends August 18th. Get started.
Necesito sumar los el presupuesto total del periodo, pero que solo respete el segmentador periodo e ignore los demas segmentadores como el mes.
Campos de tabla calendario
Solved! Go to Solution.
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
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
User | Count |
---|---|
16 | |
8 | |
7 | |
6 | |
6 |
User | Count |
---|---|
26 | |
13 | |
12 | |
8 | |
8 |