Running/Cumulative total by multiple group

[Anonymous]

Hi to all,

Need to fix something in my formula. 

I have created the following formula as common to do a running total.

Cumulative %  =

CALCULATE(

    DIVIDE([Cumulative Amount Unpaid],[Cumulative Billings]),

    FILTER(

        ALLSELECTED('Charge Regsiter Table'[Date From Period]),

ISONORAFTER('Charge Regsiter Table'[Date From Period], MAX('Charge Regsiter Table'[Date From Period]), DESC)

))

But is having an error when I put that in a Matric and add Columns to the matrix.

Matrix w/ column:

With Out Column in the Matrix:

any thoughts on why day 21 changes? also, notice that day 19 to day 22 calculation are consistent 

[v-cherch-msft]

Hi @Anonymous 

Please try below measure.If it is not your case,please share the .pbix file for us to check.You can upload it to OneDrive and post the link here.Do mask sensitive data before uploading.

Cumulative % =
CALCULATE (
    DIVIDE ( [Cumulative Amount Unpaid], [Cumulative Billings] ),
    FILTER (
        ALLSELECTED ( 'Charge Regsiter Table'[Date From Period] ),
        'Charge Regsiter Table'[Date From Period]
            <= MAX ( 'Charge Regsiter Table'[Date From Period] )
    )
)

[Anonymous]

Thanks,

that fixed it.

[v-cherch-msft · Accepted solution]

Hi @Anonymous 

Glad to hear the reply is helpful, please accept the reply as solution, that way, other community members will easily find the solution when they get same issue.

Regards,