Skip to main content
cancel
Showing results for 
Search instead 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.

Reply
Andregewehr
Helper I
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_productdatesellsvalue_accumulate_value
110/07/202251010
109/07/2022101020
108/07/202261030
107/07/202210636
106/07/20220036
105/07/20220238
104/07/202281048
103/07/202211058
102/07/202261068
101/07/2022101078
  5678422

 

But the total for accumulate_value is returning wrong in power bi

Andregewehr_0-1657806595867.png

 

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

 

1 ACCEPTED SOLUTION
AntonioM
Solution Sage
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

AntonioM_0-1657808431545.png

 

View solution in original post

4 REPLIES 4
AntonioM
Solution Sage
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

AntonioM_0-1657808431545.png

 

Perfect! Thanks!

Jihwan_Kim
Super User
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.


Go to My LinkedIn Page


amitchandak
Super User
Super User

@Andregewehr , use allselected

 

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

Helpful resources

Announcements
Microsoft Fabric Learn Together

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

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

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

April Fabric Community Update

Fabric Community Update - April 2024

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