Its a different question as both use the value 6 :D Same workbook though. For this question, please refer to worksheet 1 and 3. worksheet 1 is what i want ultimately but i use a hack now to get that value. worksheet 3 is the true value.
Thank you for attaching a packaged workbook.
For this filtering only the latest week, create calculated field like below as filter.
[The latest week]
window_min(if sum([Revenue Actual])>0 then last() END)
= (if sum([Revenue Actual])>0 then last() END)
Then show only "True" in filtering card.
See "Filter" Tab
Forecast Dashboard test_SM_9.2.twbx 120.3 KB