Matrix Filtering is Confusing please help

[eliasayyy]

Hello everyone, i cant seem to understand the logic behind the filtering in matrix

i am adding a measure called weekcheck to filter out dates based on a number range paramater to go back x number of weeks compared to today's week

Week check = 
VAR ReferenceDate =
    CALCULATE(MAX( dimDate[StartOfWeek] ), REMOVEFILTERS(dimDate))
VAR NumDays =
    SELECTEDVALUE ( Parameter[Parameter] ) * 7
RETURN
    IF ( ( ReferenceDate - NumDays ) <= MAX(dimDate[StartOfWeek]), 1 )

if i do the matrix like this i get the results i need

however the way i want to display it is putting the startofweek in the column of the matrix not row

and as soon as i do this, the filter breaks and doesnt work

as you see i have way more data back from the start of my dataset?

why is this happening and how to fix it please

[Ashish_Mathur]

Hi,

I have solved a similar question (based on months) in the attached PBI file.

[v-sshirivolu]

Hi @eliasayyy ,

I would also take a moment to thank @danextian  , for actively participating in the community forum and for the solutions you’ve been sharing in the community forum. Your contributions make a real difference.
 

I wanted to check if you had the opportunity to review the information provided. Please feel free to contact us if you have any further questions

[v-sshirivolu]

Hi @eliasayyy ,

I hope the information provided above assists you in resolving the issue. If you have any additional questions or concerns, please do not hesitate to contact us. We are here to support you and will be happy to help with any further assistance you may need.

[danextian · Accepted solution]

Hi @eliasayyy 

Try creating a filtered measure instead

Filtered Measure =
VAR ReferenceDate =
    CALCULATE ( MAX ( dimDate[StartOfWeek] ), REMOVEFILTERS ( dimDate ) )
VAR NumDays =
    SELECTEDVALUE ( Parameter[Parameter] ) * 7
VAR StartDate = ReferenceDate - NumDays
RETURN
    CALCULATE ( [your measure], KEEPFILTERS ( dimDate[StartOfWeek] >= StartDate ) )