Running total for a dynamic percentage by date and category

[MauroBote]

Hi friends (and @dustinn)

Today I've posted a message asking some help and I had a solution Dynamic percentage by date and category, but now I need to add some aditional feature: a running total for a measure generated.

I had the following table:

original table

And I had to add a dynamic measure affected by DATE visual filter, so:

1) Make a Date table. At Modeling tab, click on New Table and insert the DAX:

Date = CALENDAR(MIN('Table'[Plan Date]),MAX('Table'[Plan Date]))

2) At Model on the left side, create a relationship between the 2 tables, Table[Plan Date] = Date[Date]

3) Create a measure: 

Measure = DIVIDE(SUM('Table'[Weight]),CALCULATE(SUM('Table'[Weight]),ALLEXCEPT('Table','Table'[Project],'Date'[Date])))

And its works perfectly, per example If I select visual filter between 01-01-2019 and 31-12-2019 the results is:

But now I need to add a new column: Measure Running Total (ordered ASC by PLAN DATE and grouped by Project).

Example 1. If the visual filter is blank, the table should be (in orange the new column):

Example 2. If the visual filter is between 01-01-2019 and 31-12-2019 the results should be:

Please your help!

[v-gizhi-msft · Accepted solution]

Hi,

Please try this measure:

Measure RT = 
DIVIDE (
    CALCULATE (
        SUM ( 'Table'[Weight] ),
        FILTER (
            ALLSELECTED('Table'),
            'Table'[PROJECT] in FILTERS('Table'[PROJECT]) &&
            'Table'[PLAN DATE] <= MIN ( 'Table'[PLAN DATE] ) 
        )
    ),
    CALCULATE (
        SUM ( 'Table'[Weight] ),
        ALLEXCEPT ( 'Table', 'Table'[Project], 'Date'[Date] )
    )
)

And the result shows:

Hope this helps.

Best Regards,

Giotto Zhi