Matrix with Running Total Subtotals and Grandtotals

[tim_jim85]

I have a Matrix with Running Totals (Quantities By Date and Order Number).  I need to filter the out the values where 0  is present throughout the whole date range selected.  When I filter now it removes any row that contains a zero (filters Running total on last date instead of looking at entire range).  Below is my measure for the running total:

FinalFinalRT =

VAR CurrDevYear =Max('Date'[Date])

RETURN

CALCULATE(

    SUM(MWOLookUpQuant[RTQuant3]),

    FILTER(ALL('Date'[Date]), 'Date'[Date] <= CurrDevYear)

Thanks in advance for any advice.

[amitchandak]

@tim_jim85 , Can you share sample data and sample output in table format?

[tim_jim85]

Date	Order	Quantity
7-30	1	-100
7-30	12	-15
7-29	1	200
7-29	12	45
7-29	123	-10
7-28	123	10
7-27	1	50
7-27	12	60
7-27	123	60

Date[Date] is from a date table.

[Greg_Deckler · Accepted solution]

@tim_jim85 - This looks like a measure totals problem. Very common. See my post about it here: https://community.powerbi.com/t5/DAX-Commands-and-Tips/Dealing-with-Measure-Totals/td-p/63376

Also, this Quick Measure, Measure Totals, The Final Word should get you what you need:
https://community.powerbi.com/t5/Quick-Measures-Gallery/Measure-Totals-The-Final-Word/m-p/547907

Also, MM3TR&R might help: https://community.powerbi.com/t5/Quick-Measures-Gallery/Matrix-Measure-Total-Triple-Threat-Rock-amp-...

[tim_jim85]

Thank you very much.  Below was the option that brought me to a solution:

Also, this Quick Measure, Measure Totals, The Final Word should get you what you need:
https://community.powerbi.com/t5/Quick-Measures-Gallery/Measure-Totals-The-Final-Word/m-p/547907