Dynamic week column for a matrix

Hello,

I want that my matrix only shows the data for the week number -1.

I don't want to use a slicer where i select the week.

So I created a dataset with a measure calculating the week number -1, and then pasted this measure in a new column for this dataset as matrices dont accept a measure as a filter. This dataset only contain one line with the the name of the week, and the number of the week as a column.

I used this column on my matrix, it show the correct week number, but the data inside the matrix is the concatenation of all the weeks.

How can i create a dynamic week column for my matrix?

Thanks in advance.