Propagation of Filter context when using DAX

I understand that fitlercontext propagates from one table to another table along relationships and that it only propagates from the one side to the many side.

I can't see why DAX would not propogate it's fitlers from the many to the one side. I've been reading the book from http://ift.tt/1jNrDrH and other DAX books (by the same well known authors) and I just don't get why it would need to work like this.

See my example here: My OneNote page

This is very counter intuitive for me, and it makes me very uncomfortable. If I had written a SQL statement selecting data from tables that were related with a variety of relationships, any "filters" (ie WHERE clauses) on any of the tables reduces down the dataset that was created through including all the joined tables in the tables used. (ie the filters propagate)

I'm quite new to DAX so may be I just need to keep reading. However, in my example pivot table above, as a user of the data model, I would have really have liked to have been able to get data from the DimTime table.

If you have any useful thoughts I would very much appreciate it if you could share them!

Thanks in advance, Harvey