Incremental sum where on X axis there aren't date

[Stefano98]

Hello Everybody,

I have this situation where I have calculated the incremental points, using this formula:

Incremental point =CALCULATE(SUM('2019 - race'[Points]),

                                             KEEPFILTERS('2019 - race'[Data gara] <= MAX ( '2019 - race'[Data gara] )))

But now if I try to use this formula in a chart where on x-axis there are the tracks, it doesnt'work.

How should I change that formula in order to have the incremental points during the progress of races in the chart?

Thank you in advance

Stefano

  

[Ashish_Mathur]

Hi,

Share some data to work with and show the expected result in a Table format.

[Stefano98]

https://docs.google.com/spreadsheets/d/1NOCiy0oQBN63g-Yjn2VMLJ2lpzR74pU-/edit?usp=sharing&ouid=10540...

[Stefano98]

This is what i want to achieve, but as you can see on x - axis there are the dates, while i would like to have the tracks. Because with dates the incremental points formula works, but if i try to put the tracks, it doesnt work, that why I'm asking for. 

I would like to add the excel with data but i don't know how to attach here

[Ashish_Mathur]

Upload the file to Google Drive and share the download link.  If possible, please ensure that column headings are in English.  Furthermore, show the expected result in a Table format.  From there, you will be able to create your desired visual.

[aj1973]

Hi @Stefano98 

To calculate a running total(Incremental point) you need to add a Date_Table to your model. Join it to Data gara column, Then your measure should look some thing like this

Incremental point =

CALCULATE(

    SUM('2019 - race'[Points]),

    FILTER(

        ALLSELECTED('Date Table'[Date]),

        ISONORAFTER('Date Table'[Date], MAX('Date Table'[Date]), DESC)

    )

)

[Stefano98]

Thank you for the answer but it is not what I wanted. My problem is to have on x axis all the tracks, ordered by date, and create a meausre able to calculate for the selected driver the incremental points. My measure works if on x axis there dates, but not with tracks (you can see screenshoot in the other answer)