Alternate State issue in a straight table

[rustyfishbones]

Hi,

I have a staright table were i am calculating the following expression NUM(MAX({altDate}[Stat Week])-MAX([Stat Week])), all other expressions are comparing a from date and to date and they work fine, i also tried using the following

NUM(Week(MAX({altDate}[Stat Date]))-WEEK(MAX([Stat Date]))).

So the straight table displays the total but not the lines level detail and its confusing as hell.

[Brett_Bleess]

You will have to provide some additional information on this one, no idea what we are trying to help you solve here.  Probably the most helpful thing would be your expected output and potentially the input records to be able to tell what it is we are trying to do here.  

Regards,
Brett