
Hi All,
I have a dual axis chart (Sheet: Chart) the two measures are 1. 'Time taken' and 2. 'Rolling avg calc'.
I would like to filer the Timestamp(Copy) date. However, whenever I do so the table calculation measure ('Rolling avg calc') also recalculates itself.
is it possible to filter to a date range without affecting the table calc measure filed ('Rolling avg calc').
I have attached the workbook that contains the worksheet (Chart).
Please advise. Thank you.
Regards,
Rishi Saka