cancel
Showing results for
Did you mean:
Anonymous
Not applicable

## Running total of measure

Hi all

I have been googling and reading posts a lot, but I still can't find a solution.

The root of my problem is probably the way the running total is calculated, but I can't find the reason.

 Year Month Day LJ_MAX_SUM RT_LJ_MAX_SUM What I want 2020 January 1 917 917 917 2020 January 2 907 1731 1824

The data of the last 5 years:

 Year Month Day Sum per day 2016 January 1 543 2016 January 2 664 2017 January 1 515 2017 January 2 585 2018 January 1 712 2018 January 2 907 2019 January 1 917 2019 January 2 814 2020 January 1 1104 2020 January 2 1180

``````LJ_MAX_SUM=
VAR Temp=
UNION(
)
RETURN
MAXX(Temp, [test2])/1000``````

``````RT_LJ_SUM_MAX = CALCULATE (
[LJ_MAX_SUM],
FILTER (
ALLSELECTED(  'Calendar_future'),
'Calendar_future'[Date] <= MAX ( 'Calendar_future'[Date] )
)
)``````

The measure ''RT_LJ_SUM_MAX' takes the green and blue marked value and calculates the running total. What I want is, that it takes the green and red value to calculate the running total.

How can I do this?

1 ACCEPTED SOLUTION
Community Support

Try this:

``````RT_LJ_SUM_MAX =
SUMX (
FILTER (
ALLSELECTED ( 'Calendar_future' ),
'Calendar_future'[Date] <= MAX ( 'Calendar_future'[Date] )
),
[LJ_MAX_SUM]
)
``````

Or this:

``````RT_LJ_SUM_MAX =
SUMX (
FILTER (
ALLSELECTED ( 'Calendar_future' ),
'Calendar_future'[Date] <= MAX ( 'Calendar_future'[Date] )
&& Calendar_future[Date]. [Year] = MAX ( Calendar_future[Date].[ Year] )
),
[LJ_MAX_SUM]
)
``````

Best regards

Icey

If this post helps,then consider Accepting it as the solution to help other members find it faster.

2 REPLIES 2
Community Support

Try this:

``````RT_LJ_SUM_MAX =
SUMX (
FILTER (
ALLSELECTED ( 'Calendar_future' ),
'Calendar_future'[Date] <= MAX ( 'Calendar_future'[Date] )
),
[LJ_MAX_SUM]
)
``````

Or this:

``````RT_LJ_SUM_MAX =
SUMX (
FILTER (
ALLSELECTED ( 'Calendar_future' ),
'Calendar_future'[Date] <= MAX ( 'Calendar_future'[Date] )
&& Calendar_future[Date]. [Year] = MAX ( Calendar_future[Date].[ Year] )
),
[LJ_MAX_SUM]
)
``````

Best regards

Icey

If this post helps,then consider Accepting it as the solution to help other members find it faster.

Anonymous
Not applicable

Hi @Icey

Both solutions work!

Best regards,

Announcements

#### Power BI September 2023 Update

Take a look at the September 2023 Power BI update to learn more.

#### Learn Live: Event Series

Join Microsoft Reactor and learn from developers.

#### Exclusive opportunity for Women!

Join us for a free, hands-on Microsoft workshop led by women trainers for women where you will learn how to build a Dashboard in a Day!

#### Power Platform Conference-Power BI and Fabric Sessions

Join us Oct 1 - 6 in Las Vegas for the Microsoft Power Platform Conference.

Top Solution Authors
Top Kudoed Authors