create table with cumulative measures

Hi rufmau68 

I think your CMSCardinis Table is the same as below.

Then you build a summarize table :SparklineTable_Debug.

SparklineTable_Debug =
SUMMARIZE(CMSCardinis, CMSCardinis[Codice WBS], CMSCardinis[Mese di Rendicontazione].[Date], "Y", sum(CMSCardinis[Giornate]))

To calculate the running total of Y for each Codice WBS, you could build a measure like amitchandak's reply, or you could build a calculated column.

Measure:

Basic Measure = 
CALCULATE (
    SUM ( [Y] ),
    FILTER (
        ALL ( SparklineTable_Debug ),
        SparklineTable_Debug[Codice WBS] = MAX ( SparklineTable_Debug[Codice WBS] )
            && SparklineTable_Debug[Date] <= MAX ( SparklineTable_Debug[Date] )
    )
)

Measure_Y_cumulato = SUMX(SparklineTable_Debug,[Basic Measure])

Basic will show wrong Total in table visual, so we need to build a new one basiced on Basic Measure.

Or you could build a calculated column in SparklineTable_Debug Table.

Column_Y_cumulato =
CALCULATE (
    SUM ( [Y] ),
    FILTER (
        SparklineTable_Debug,
        SparklineTable_Debug[Codice WBS] = EARLIER ( SparklineTable_Debug[Codice WBS] )
            && SparklineTable_Debug[Date] <= EARLIER ( SparklineTable_Debug[Date] )
    )
)

Result:

You can download the pbix file from this link: create table with cumulative measures

Best Regards,

Rico Zhou

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.