Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Compete to become Power BI Data Viz World Champion! First round ends August 18th. Get started.

Reply
Jens1983
Regular Visitor

Cumulative Actuals with Filtering

Hi everybody,

 

for cumulating my actuals i used the following code and it works fine:

 

Cumulative Actuals = CALCULATE(SUM(Actuals[VAlue]), FILTER(All(Actuals), Actuals[Period] <= MAX(Actuals[Period])))

 

But the problem is, that when i want to attach filters to my visuals, they are being ignored. How do i get this flexibility? I think ithas something to do with the "All" Funktion in the code which keeps ignoring filters?

 

Greetings

 

Jens 

1 ACCEPTED SOLUTION
Anonymous
Not applicable

Hi @Jens1983 ,

 

I want to validate the valuable input provided by @nandic . Their initial thoughts helped guide my approach. However, I noticed that more detail is needed to fully understand the problem.

 

In the ALLSSELECTED calculation, only the filters inside the visual object are ignored. This is different from the way ALL behaves. From the ALL function's point of view, all filters inside or outside the visual object are ignored. More details can be found in the link : Power BI DAX: ALL vs. ALLSelected - RADACAD.

 

I created two MEASURES.

Measure =
CALCULATE(SUM(financials[ Sales]),FILTER(ALL(financials),'financials'[Date] <= MAX('financials'[Date])))

 

Measure 2 =
CALCULATE(SUM(financials[ Sales]),FILTER(ALLSELECTED(financials[Date]),'financials'[Date] <= MAX('financials'[Date])))


They return the same result when there is no data selected in the slicer.

vkaiyuemsft_0-1715674031328.png

 

When I filter in the slicer, the MEASURES remain the same results, while MEASURES 2 returns the new values. More details can be found in the pbix attachment.

vkaiyuemsft_1-1715674041202.png

 

If your Current Period does not refer to this, please clarify in a follow-up reply.

 

Best Regards,

Clara Gong

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

2 REPLIES 2
Anonymous
Not applicable

Hi @Jens1983 ,

 

I want to validate the valuable input provided by @nandic . Their initial thoughts helped guide my approach. However, I noticed that more detail is needed to fully understand the problem.

 

In the ALLSSELECTED calculation, only the filters inside the visual object are ignored. This is different from the way ALL behaves. From the ALL function's point of view, all filters inside or outside the visual object are ignored. More details can be found in the link : Power BI DAX: ALL vs. ALLSelected - RADACAD.

 

I created two MEASURES.

Measure =
CALCULATE(SUM(financials[ Sales]),FILTER(ALL(financials),'financials'[Date] <= MAX('financials'[Date])))

 

Measure 2 =
CALCULATE(SUM(financials[ Sales]),FILTER(ALLSELECTED(financials[Date]),'financials'[Date] <= MAX('financials'[Date])))


They return the same result when there is no data selected in the slicer.

vkaiyuemsft_0-1715674031328.png

 

When I filter in the slicer, the MEASURES remain the same results, while MEASURES 2 returns the new values. More details can be found in the pbix attachment.

vkaiyuemsft_1-1715674041202.png

 

If your Current Period does not refer to this, please clarify in a follow-up reply.

 

Best Regards,

Clara Gong

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

nandic
Super User
Super User

@Jens1983 function ALL removes all filters from table Actuals and then applies only period <= max period.
Everything else is not applied due to ALL function.

What you can try is to do ALL(Actuals[Period]) - so removing filters impacting only this column, not whole table.
Or using ALLSELECTED(Actuals) instead of ALL(Actuals).

Cheers,
Nemanja Andic

Helpful resources

Announcements
August Power BI Update Carousel

Power BI Monthly Update - August 2025

Check out the August 2025 Power BI update to learn about new features.

August 2025 community update carousel

Fabric Community Update - August 2025

Find out what's new and trending in the Fabric community.