Forum Discussion

mitchperkins's avatar
mitchperkins
Regular Visitor
4 years ago

Cumulative Total without Date Table

I want to track a cumulative total for RMR sold on a MTD/QTD/YTD basis. I have a table, v_rpt_Opportunity, that has columns of Date_Closed and RMR. I have attempted to write the cumulative total measure as follows:

 

Cumulative RMR = CALCULATE(
SUM('v_rpt_Opportunity'[RMR]),
FILTER(
ALL(v_rpt_Opportunity),
'v_rpt_Opportunity'[Date_Closed] <= MAX('v_rpt_Opportunity'[Date_Closed])
)
)

 

However, every time I create this measure, it shows me the cumulative RMR sold on a specific day. I'm wanting to be able to put a filter on a visual with this, or a slicer on the page, that allows you to select MTD/QTD/YTD but each time I do this it shows me the daily totals, not the running total for the timeframe. 

 

Any suggestions?

Need Help

2 Replies

  • mitchperkins's avatar
    mitchperkins
    Regular Visitor
    4 years ago

    I end up with charts such as this when attempting to show a cumulative total over time

  • v-angzheng-msft's avatar
    v-angzheng-msft
    Community Support
    4 years ago

    Hi, mitchperkins 

     

    Are you saying that the cumulative totals measure is not working properly and is showing daily totals on the chart?
    I think your measure formula is correct and am not sure what went wrong.
    Could you please consdier sharing more details about it or a simple sample file without any sesentive information for further discussion?

     

     

    Best Regards,
    Community Support Team _ Zeon Zheng
    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.