Running Total Struggles

JWhitford 

Try this.

1) First create a calculated column to establish the YearPeriod for your table:

YearPeriod Column = Table[Year] * 100 + Table[Period]

2) Next create a dimension table for your YearPeriod/Year/Period

 3) Join the Dim YearPeriod Table to your fact table in a one-to-many relationship

5) Create a measure which is the sum of the column you have created for Raised Files:

Sum of Files Raised = SUM(Table1[Files Raised])

6) Create the running totals measures you need:

Running total YearPeriod = 
CALCULATE([Sum of Files Raised], 
               FILTER(ALL ('Dim YearPeriod'),  
                   'Dim YearPeriod'[YearPeriod] <= MAX('Dim YearPeriod'[YearPeriod])))

Running total by period = 
CALCULATE([Sum of Files Raised], 
            FILTER(ALL ('Dim YearPeriod'),  
                 'Dim YearPeriod'[Period] <= MAX('Dim YearPeriod'[Period])))

Running total by Year = 
CALCULATE([Sum of Files Raised], 
                  FILTER(ALL('Dim YearPeriod'), 
                        'Dim YearPeriod'[Year] <= MAX('Dim YearPeriod'[Year])))

And this is the result: