Forum Discussion

scottnich1986's avatar
scottnich1986
New Member
2 years ago

Running Total with Measure that Includes Filters

I'm looking to show how over what time we receive bookings to fill our buildings, with 2 concrete time periods - Semester 1 and Semester 2. I've been able to solve how many bookings are received for a certain time period and how far in advance these bookings are received compared to our fill date, but then can't get it to successfully show as a running total. 

 

Data set below showing the Count of Bookings by Month leading up to the time period.

 

 

Measure to create this as follows:

[Measure Booking Created] = COUNTA('SRA2 Booking'[DateCreated])

Measure Bookings Created running total in Column Booking Months Created before Census Sem 2 =
CALCULATE(
    [Measure Bookings Created],
    FILTER(
        ALLSELECTED('SRA2 Booking'[Column Booking Months Created before Census Sem 2 v2]),ISONORAFTER('SRA2 Booking'[Column Booking Months Created before Census Sem 2 v2],MAX('SRA2 Booking'[Column Booking Months Created before Census Sem 2 v2]),DESC)))
 

But when I put this into a line chart, the final line (Sem 2 2024) drops away in the final period, rather than adding to the prior month and when I add the month's together, I get differences in the total. 

 

 

Any help would be great.

 

Scott

 

 

 

Need Help