cancel
Showing results for
Search instead for
Did you mean:
Frequent Visitor

## Acumulate pivot Formula

Hi everybody

I 'm worwing whit a custom report and i use this Dax to calculate the value,

Saldo Balance=
SUMX (
Reporting_Balanace;
CALCULATE (
SUM (Consolidated [BALANCE]) / 1000 * -1;
FILTER (
ALL (Reporting_Balanace);
PATHCONTAINS (Reporting_Balanace [Path]; EARLIER (Reporting_Balanace [ID_Report_Balance]; 1))
)
)
)

This calculate works well, the poblem is when i try to accumulate the value month by mont

I've Tryed with the follow dax

Saldo total acumulado = CALCULATE([Saldo Balance]; FILTER(ALLSELECTED(Consolidada);Consolidada[Fecha]<=MAX(Consolidada[Fecha])))

Any idea how to do that works

Thank you very much for you time

Gabriel

1 REPLY 1
Community Support Team

## Re: Acumulate pivot Formula

Hi

So the table 'Consolidada' and 'Reporting_Balanace' are two tables, right? They have relationship, right? The issue may caused by you cannot use "allselected" in one table to filter another table. Suppose they have relationship based on column [Index], you may modify your measure like pattern below and check if it can solve your issue.

```Saldo total acumulado =CALCULATE ( [Saldo Balance]; FILTER ( ALL ( Reporting_Balanace ); Reporting_Balanace[Index] IN VALUES ( Consolidada[Index] ) ))
```

Regards,

Jimmy Tao

## Helpful resources

Announcements

#### How to Get Your Question Answered Quickly

Power BI Super User, Greg Deckler, explains

#### Power Platform Summit North America

Register by September 5 to save \$200

#### Back to School Contest

Engage and empower students with Power BI!

#### Watch Sessions On Demand!

Continue your learning in our online communities.

Top Ideas
Top Kudoed Authors
Users Online
Currently online: 42 members 1,167 guests
Recent signins:
Please welcome our newest community members: