Current Week versus Last Week Totals as a Bar Chart

Hi Anonymous ~

I created a sample:

Please try these measures:

Current Week = 
var __Today = TODAY()
var __WeekStartDate = __Today-WEEKDAY(__Today,1)+1
var __WeekEndDate = __WeekStartDate+6
return
CALCULATE(COUNTROWS('Table'),FILTER(ALL('Table'),__WeekStartDate<='Table'[Closed] && __WeekEndDate>='Table'[Closed]))

Last Week = 
var __Today = TODAY()
var __WeekStartDate = __Today-WEEKDAY(__Today,1)-6
var __WeekEndDate = __WeekStartDate+6
return
CALCULATE(COUNTROWS('Table'),FILTER(ALL('Table'),__WeekStartDate<='Table'[Closed] && __WeekEndDate>='Table'[Closed]))

create a table:

create a measure:

Measure Value = 
SWITCH(
SELECTEDVALUE('Table1'[order]),
1,[Current Week],
2,[Last Week]
)

Finally create a bar chart:

Hope it helps!

Best regards,

Community Support Team  Gao

If this post helps, please consider Accept it as the solution to help the other members find it more quickly.