DAX Index Measure

I've been trying to write a measure to give me an index; I've got it working but could do with some help also If anyone would like to suggest aa better method please do.

my initial attempt was ;

Please Login or Register  to view this content.

Using ALL(Table1[Date], but this gave the number 1 for each 'row', but by using

Please Login or Register  to view this content.

, it works fine, I have uploaded the work book showing both examples.


Richard