Cumulative Total with multiple filter selection

[Syndicate_Admin]

I have a database containing dates from different years and 7 projects (which are segmented by different types) of which, I need to generate a table containing:
1. Income

2. Expenses

3. Income - Expenses

4. Accumulated of the total that gives (Income - Expenses)
EXAMPLE:

I already managed to do all the previous steps, but I have certain points that do not manage to stay.
1. When generating the table at a glance, in January of each year the accumulated is restarted and I do not want it to do that.
EXAMPLE:

2. When you filter it for a single project there is (OK) the accumulated, it does not restart and the accumulated is correct.

EXAMPLE:

3. When I filter 1 or more projects, the accumulated is no longer done correctly and in some games it does not mark any result and I need to call the consecutive accumulated regardless of the project or the date.

EXAMPLE:

Within Power BI, I have the following calculated fields:

EGRESO = CALCULATE(SUM(FLUJOSPROYPRUEBA[Amount]),'FLUJOSPROYPRUEBA'[Type of Operation]= "Graduation")

INCOME = CALCULATE(SUM(FLOWSPROYTEST[Amount]),'FFLOWSPROYTEST'[Type of Operation]= "Income")

I-E = [All.General]

Tot.General = ('Tablas_medida'[INCOME]-'Tablas_medida'[EGRESO])

Cumulative 1 =

WHERE SelectedCategory = SELECTEDVALUE('FFLOWSPROYPRUEBA'[Project])

RETURN

IF(

ISFILTERED('FLUJOSPROYPRUEBA'[Project]),

CALCULATE(

SUM('FLUJOSPROYPRUEBA'[I-E]),

FILTER(

ALL('FLUJOSPROYPRUEBA'),

'FFLOWSPROYPRUEBA'[Date] <= .MAX('FLUJOSPROYPRUEBA'[Close]) &&

'FLOWSPROYTEST'[Project] = SelectedCategory

)

),

TOTALYTD(SUM('FLUJOSPROYPRUEBA'[I-E]), 'FLUJOSPROYPRUEBA'[Close], ALL('FLOWSPROYTEST'[Date]))

)

Is there any way to make the accumulated do not break in time or with multiple selections of projects?, if so could you help me know? Thank you.

[Syndicate_Admin]

Nice day!
Try to place what you tell me and it does not work for me, could you be more specific?
or can you help me find another solution?


Thank you

[parry2k]

@Syndicate_Admin change this part, although when you are working dates, you should have date dimension in your model.

CALCULATE ( SUM('FLUJOSPROYPRUEBA'[I-E]), FILTER ( ALL ( Table[Date] ), Table[Date] <= MAX ( Table[Date] ) ) )

👉 Learn Power BI and Fabric - subscribe to our YT channel - @PowerBIHowTo

If my solution proved useful, I'd be delighted to receive Kudos. When you put effort into asking a question, it's equally thoughtful to acknowledge and give Kudos to the individual who helped you solve the problem. It's a small gesture that shows appreciation and encouragement! ❤️