Forum Discussion

IC95's avatar
IC95
New Member
1 year ago

Running Total Not Working

Hi,    I hope someone can help me.   I have the Total Hours Efficiency Workcentre ( data I have)   I then have a measure with the Average Demonstrated Capacity(Last 3 Months)   Average...
Anonymous's avatar
Anonymous
Not applicable
1 year ago

Hi IC95 ,

 

You can try the following expression. 

Carry Over Past Dues = 
CALCULATE(
    SUMX(
        FILTER(
            ALLSELECTED('DIM_Date'),
            'DIM_Date'[theDate] <= MAX('DIM_Date'[theDate])
        ),
        [Past Dues]
    )
)


If this doesn't help.  Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data. We can better understand the problem and help you.

 

 

Best Regards,

Clara Gong

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