Forum Discussion

eliasayyy's avatar
eliasayyy
Icon for Memorable Member rankMemorable Member
11 months ago
Solved

Matrix Filtering is Confusing please help

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 ...
Need Help
  • danextian's avatar
    danextian
    11 months ago

    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 ) )
Anonymous's avatar
Anonymous
Not applicable
11 months ago

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

 

  • Anonymous's avatar
    Anonymous
    Not applicable
    11 months ago

    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.