cancel
Showing results for
Did you mean:

Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.

Helper I

## Wrong accumulated values total sum

I have the following table with a accumulate value measure:

_accumulate_value =SUMX(VALUES('Table'[date]),
CALCULATE(sum('Table'[value]),FILTER(ALL('Table'[date]),[date]>=MAX('Table'[date]))))

 id_product date sells value _accumulate_value 1 10/07/2022 5 10 10 1 09/07/2022 10 10 20 1 08/07/2022 6 10 30 1 07/07/2022 10 6 36 1 06/07/2022 0 0 36 1 05/07/2022 0 2 38 1 04/07/2022 8 10 48 1 03/07/2022 1 10 58 1 02/07/2022 6 10 68 1 01/07/2022 10 10 78 56 78 422

But the total for accumulate_value is returning wrong in power bi

How can i fix it to get the total sum 422 instead of 100?

1 ACCEPTED SOLUTION
Solution Sage

You could create one more measure

``````Measure =
IF(
HASONEVALUE('Table'[date]),
[_accumulate_value],
SUMX(
VALUES('Table'[date]),
[_accumulate_value]
)
)``````

which gives you 422

4 REPLIES 4
Solution Sage

You could create one more measure

``````Measure =
IF(
HASONEVALUE('Table'[date]),
[_accumulate_value],
SUMX(
VALUES('Table'[date]),
[_accumulate_value]
)
)``````

which gives you 422

Helper I

Perfect! Thanks!

Super User

Hi,

Please try the below measures and the attached pbix file.

both of them should work.

``````_accumulate_value V2 =
SUMX (
VALUES ( 'Table'[date] ),
CALCULATE (
CALCULATE (
SUM ( 'Table'[value] ),
FILTER ( ALL ( 'Table'[date] ), 'Table'[date] >= MAX ( 'Table'[date] ) )
)
)
)
``````

``````_accumulate_value =
SUMX (
VALUES ( 'Table'[date] ),
CALCULATE (
SUMX (
VALUES ( 'Table'[date] ),
CALCULATE (
SUM ( 'Table'[value] ),
FILTER ( ALL ( 'Table'[date] ), [date] >= MAX ( 'Table'[date] ) )
)
)
)
)
``````

If this post helps, then please consider accepting it as the solution to help other members find it faster, and give a big thumbs up.

Super User

@Andregewehr , use allselected

_accumulate_value =SUMX(VALUES('Table'[date]),
CALCULATE(sum('Table'[value]),FILTER(allselected ('Table'[date]),[date]>=MAX('Table'[date]))))

Announcements

#### Microsoft Fabric Learn Together

Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City

#### Power BI Monthly Update - April 2024

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

#### Fabric Community Update - April 2024

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

Top Solution Authors
Top Kudoed Authors