Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
10 years ago

Report filter automatic result

Hello experts!   I need to filter the report to recognize the most recent date, then filter to only show results for the group of that date. For example...   The most recent event date on the dat...
Sean's avatar
Sean
Community Champion
10 years ago

Anonymous Create the 2 Measures and then replace [Date] in your Table Visual with Last Date and [Event#] with Last Event#

 

Last Date = 
CALCULATE ( LASTDATE ( 'Table'[DATE] ), ALL ( 'Table' ) )

Last Event# =
CALCULATE (
    VALUES ( 'Table'[Event#] ),
    LASTDATE ( 'Table'[DATE] ),
    ALL ( 'Table' )
)
Anonymous's avatar
Anonymous
Not applicable
10 years ago

Thanks!  This works to create the data for the most recent Event# recorded (thakn you!!).  However, the system won't let me use this Measure as a Report Filter.  (can't drag it into the report filter box).  Any ideas?

  • Sean's avatar
    Sean
    Community Champion
    10 years ago

    Last Date formula will work as a column too...

    • Anonymous's avatar
      Anonymous
      Not applicable
      10 years ago

      Thanks Sean, Sorry for the rooky questions.  How do I use these in the Page FIlter setting?  When I drag the info in (either columns or measurews), it still requires me to select and event#

       

      Basically, Im trying not to over load the reader with data, so want the page to automatically filter to show only the current event data.  (most recent event).  

       

      Thanks for your support on this!