Accumulate a measure in a matrix Table

[carlosss897]

Hi everyone,

I need to accumulate a sum based on my measure ‘Sales’. The Matrix Table is in descending order, from highest to lowest Sales. Here is an example on Excel:

Now, I see a lot of solutions to do that with accumulative totals based on columns. But in this case, I need to accumulate a Measure since Sales is a measure.

I found this code in a Thread, but I am not able to use a Measure in it:

CALCULATE (

    SUM ( 'All Web Site Data (2)'[UniquePageviews] ),

    FILTER (

        ALL ( 'All Web Site Data (2)' ),

        'All Web Site Data (2)'[Date] <= MAX ( 'All Web Site Data (2)'[Date] )

    )

)

Can someone help me out?

Cheers, carlos

[carlosss897]

oh wow that was easy. thank you so much!

[Jihwan_Kim · Accepted solution]

Hi,

Please check the below picture and the attached pbix file.

accumulative total: =
VAR _sales = [Sales measure:]
RETURN
    CALCULATE (
        [Sales measure:],
        FILTER ( ALL ( Data[Customer] ), [Sales measure:] >= _sales )
    )