Running Total Measure that goes by row and column in Matrix if possible..

[mdhenzel]

Hi All, This is something that is probably not possible, but I would like to ask first before giving up. I am building a running inventory visual for an area of a report. I used a measure that has worked before for me, but that was for looking at a material overall across time. Now, doing it by customer and material throws it off. Is it possible to have this measure work top to bottom or something? Example: June 29th top value of 19 (not -1), then the lower would still take the 3 off for the total of 16. I have it down to the day to solve issue, but data will be looked at as month to month.  

[amitchandak]

@mdhenzel , Not very clear. But you use a date table and use that in visual too

then this will only give cumulative across date for material/customer combination

Cumm Sales = CALCULATE(SUM(Sales[Sales Amount]),filter(all('Date'),'Date'[date] <=max('Date'[date])))

or allselected

Cumm Sales = CALCULATE(SUM(Sales[Sales Amount]),filter(allselected('Date'),'Date'[date] <=max('Date'[date])))

if use the table(sales in above example) in place of the date table, then you need to add additional conditions

[mdhenzel]

Hi there, I currently am using the following measure:

Inv. Running =

Var First = [Unrestricted to Use]

VAR LastVisibleDate =

MAX ( 'Date Table'[Date] )

VAR FirstVisibleDate =

MIN ( 'Date Table'[Date] )

VAR LastDateWithSales =

CALCULATE (

MAX ( 'Ready To Ship'[Customer Requirement Date] ),

REMOVEFILTERS ()

)

VAR Result =

First +

IF (

FirstVisibleDate <= LastDateWithSales,

CALCULATE (

[Orders to Ship] ,

'Date Table'[Date] <= LastVisibleDate

)

)

RETURN

Result

This is only getting me the correct values at the total level for the columns. Not through the values, as shown in my images. 

I do have a date table and it is being used as the columns in the matrix. 

[mdhenzel]

To Add, for July, it would be 16 - 15 for 11, - 25 for -14 and so on. If not possible, do we know why the measure is working in this way?