I created a Running Total Quick Measure by Month, which I am filtering to only the last 6 months. When filtered, the totals begin with the total from the first month displayed, and not from the beginning. I would like for the total on the first month start with the total from the beginning of time, and not from that month. Is this possible? Below is the formula from the Quick Measure and a screen shot of the table.
Hi @ScottR-MT ,
Please create an extra measure, add it to Matrix.
New Measure = SUMX ( ActualTableName, [IB] )
Let me clarify. The running total formula works as it is supposed to when all of the data is unfiltered in the visual. I only want to show the last 3 months, but when I do that, the running total starts at the earliest month shown in the visual after filtering. I want the total of the earliest month to be the total from all months from the beginning. If it works as I would like it to in the bottom table, Dec-18 should be 80, and then grow from there. I have attached an example PBI file, and added the below screenshot to show the difference.
The top table is unfiltered, and the running total is correct. In the bottom table, I filtered by the last 3 months, and as you can see, it does not give me the actual total from the beginning of time, but rather the total starts from the first month in the visual.
Any help would be greatly appreciated!
Download: PBI Running Total Example
Count of Serial Number running total in Install Month = CALCULATE( DISTINCTCOUNT('Data'[Serial Number]), FILTER( CALCULATETABLE( SUMMARIZE('Data', 'Data'[Month No], 'Data'[Install Month]), ALLSELECTED('Data') ), ISONORAFTER( 'Data'[Month No], MAX('Data'[Month No]), DESC, 'Data'[Install Month], MAX('Data'[Install Month]), DESC ) ) )