Latest date filter

Hi manah77g 

Thank you very much Ritaf1983 for your prompt reply.

Is your problem solved? If not, here are some solutions I can provide:

Here's some dummy data

“Table”

If you want to implement page-level filtering, try:

Create a column.

Latest date = 
var _maxDate = CALCULATE(MAX('Table'[Date]), ALL('Table'))
RETURN
IF(
    'Table'[Date] = _maxDate,
    1,
    0
)

If you want to implement visual-level filtering, try:

Create a measure.

Measure Latest date = 
var _maxDate = CALCULATE(MAX('Table'[Date]), ALL('Table'))
RETURN
IF(
    SELECTEDVALUE('Table'[Date]) = _maxDate,
    1,
    0
)

Click the visual you want to filter:

Regards,

Nono Chen

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.