Forum Discussion

jcastr02's avatar
jcastr02
Post Prodigy
1 year ago
Solved

Filter by a Measure

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 al...
Need Help
  • bhanu_gautam's avatar
    bhanu_gautam
    1 year ago

    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.

bhanu_gautam's avatar
bhanu_gautam
Super User
1 year ago

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.