Filter by a Measure

[jcastr02]

I have this Measure Used in Matrix Table as value because I only want the last week displayed in the matrix, otherwise the category value will show up every week and it’s a bit of an eye sore.   I also have a filter on the page for the HTS Category New, but what happens it is brining values from previous weeks, Is there a way to have this measure show up as a filter since I only want to filter by the latest week.  I also tried to apply a filter on the Category field to only show latest top 1 week but that didn’t work either.  Any help is appreciated.

HTS Category_For Matrix =

VAR _maxweek=

    CALCULATE( MAX ( 'Table'[Week] ), ALLSELECTED ('Table' ))

RETURN

    IF (

        SELECTEDVALUE( 'Table'[Week] ) = _maxweek,

        MAX ( 'Table'[HTS Category New] ),

        BLANK ()

    )

[bhanu_gautam · Accepted solution]

@jcastr02 There is an improved version of your measure that ensures only the latest week's data is displayed:

HTS Category_For Matrix =
VAR _maxweek =
CALCULATE(MAX('Table'[Week]), ALL('Table'))
RETURN
IF(
SELECTEDVALUE('Table'[Week]) = _maxweek,
MAX('Table'[HTS Category New]),
BLANK()
)

And then create a new measure to identify the latest week:

LatestWeekFlag =
VAR _maxweek =
CALCULATE(MAX('Table'[Week]), ALL('Table'))
RETURN
IF(MAX('Table'[Week]) = _maxweek, 1, 0)

Add the LatestWeekFlag measure to your matrix visual.
Set the filter condition to show only where LatestWeekFlag is 1.

[jcastr02]

@bhanu_gautam THANK YOU!!!! this worked!