Compare Current Day with the last 7 days average

[larain9627-1646]

Hi

I’m trying to build a look/table which shows a measure for current day value, as well as an average of the last 7 days. The issue is this measure is a “number” type cuz it’s a calculation of division. So I’m having trouble creating this measure with filters of date_day_date. Is there any other ways to have the same measure but applied with different time frame/filter in the same look/dashboard?

Thanks!