Change value of measure entry by filter

[Sander_nl_]

Hi community,

Im looking into a graph, but it requires me to make measure that changes based on a filter.

Basically, ive got a table in which there are measures and each measure has a value in column A. what i need are two columns that are start and endpoint. The startpoint of measure 1 is 0 and will continue to the value in column A. measure 2 will start with the endpoint of measure 1, and so fort. 
see picture for an example.

The end point is basically the startpoint + value.

This is what i got for the start; ive used an index that is static in order to have a rigid point. 

StartingPoint =

CALCULATE(

    SUM('Table'[value]),

    FILTER(

        ALL('Table'),

        'Table'[Index] < MIN('Table'[Index])

    )

)

I hope there is someone that can help 🙂

[Sander_nl_]

Hi Tamerj1,

Thank you for your reply. Unfortunately it doenst work how i want it and in my own file it doenst work at all.
Im rereading my inital question and i see that i forgot to mention the filter i want to use. My apologies.

When I open your file the tabel works, but when i filter the table it just filters and it doenst change the numbers in the start and end column. As you can see in the picture. So when i filter for index 3, i want it to start at 0 and end at 6. if i do index 3 and 6 then i want 6 to start with 6 and end with (6+12)

In my own file it gives me an error in the Earlier () command. it says "parameter is not the right size". it doenst work with any of the columns in the tabel. so there might be something wrong with the way i saved the table?

[tamerj1 · Accepted solution]

@Sander_nl_ 
The first solution is a calculated column. To have a dynamic solution you need to create a measure.

[Sander_nl_]

Thanks a lot!

I now also understand how it works.

[tamerj1]

Hi @Sander_nl_ 
Please see attached sample file with  the proposed solution