Re posting question as I got my tables confused.

[dicken]

I hope I've got my row / filer the the right way round,

I created two measures one using the dates from the fact table the other from the calendar table

SQL:
RTM using C = VAR mcdate = MAX('Calendar'[Date])
VAR anser = CALCULATE([Tsales],FILTER(ALL('Calendar'[Date]),'Calendar'[Date]<= mcdate))
RETURN IF([Tsales],anser )

and the same but rather than using calendar table using the dates form the fact table

SQL:
RTM using Rsaels Date =
VAR maxdate = MAX(RTsales[Date])
VAR anser2 = CALCULATE([Tsales],FILTER(ALL(RTsales[Date]),RTsales[Date]<= maxdate))
VAR iff = IF([Tsales], anser2 )

they both work on their respective matrix's 'matrices'? , but when another element is dropped in
the matrix using the RTsales Date table, still returns a running total by date ignoring the current 'row', so as can be seen March 7th returns 42, correct but not what I want, I don't know if Bi works differently from pivot where they would both work the same.

I've been over the measures, and tried different things, but can't see why 'b' doesn't work., you can't see the title but the second columns is running total based on the calendar in the matrix.
Any suggestions,

RD

RD