cancel
Showing results for
Did you mean:

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Frequent Visitor

## Calculating a running total from a measure

Hi All,

I am trying to create a running total from a measure using this formula:

runningtotal = SUMX(FILTER(ALLSELECTED('Calendar'[MonthYear]), 'Calendar'[MonthYear] <= MAX('Calendar'[MonthYear])),[fc_FB_Change])

The running total is just mirroring the results for [fc_FB_change] as shown in the picture below
Can anyone help solve this please?
fc_FB_change is a mesaure that calculates the difference between two other measures.
1 ACCEPTED SOLUTION
Community Support

Hi @HFoy ,

To update the measure should work.

`runningtotal = SUMX(FILTER(ALLSELECTED('Calendar'),'Calendar'[Date]<=MAX('Calendar'[Date])),'Table1'[fc_FB_Change])`

Regards,

Frank

Community Support Team _ Frank
If this post helps, then please consider Accept it as the solution to help the others find it more quickly.
Community Support

Hi @HFoy ,

To update the measure should work.

`runningtotal = SUMX(FILTER(ALLSELECTED('Calendar'),'Calendar'[Date]<=MAX('Calendar'[Date])),'Table1'[fc_FB_Change])`

Regards,

Frank

Community Support Team _ Frank
If this post helps, then please consider Accept it as the solution to help the others find it more quickly.

Announcements

#### Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

#### Power BI Monthly Update - August 2024

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

#### Fabric Community Update - August 2024

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

Top Solution Authors
Top Kudoed Authors