Show text on Card visual with Latest Date when nothing is selected

[gp10]

I want to have a card where I will show the latest date of a dataset refresh when a report name is selected. And I would like to show a text message like "Last Refresh" when nothing is selected.

I have 2 connected tables one for Reports where I have the reports and their dataset IDs, and one for Last Refresh with the dataset IDs and their latest refresh date.

If I just drop the Latest Refresh column in a card visual and select to show the latest date I get the correct result. But when no report is selected I still see a date there and I would like a text.

Any thoughts? Thanks.
The usual measures with IF condition and Hasonevalue and SelectedValue doesn't seem to work.

[PaulDBrown · Accepted solution]

Try:
Last Refresh = IF(ISFILTERED(SlicerTable), MAX(Table[LastRefreshColumn]), "Last Refresh")

[PaulDBrown · Accepted solution]

Try:
Last Refresh =
VAR MX = CALCULATE(MAX(Table[LastRefreshColumn]), ALL(Table)
RETURN
IF(ISFILTERED(SlicerTable), MX, "Last Refresh")

[PaulDBrown]

Try something along the lines of:

Last Refresh =IF(ISFILTERED(SlicerTable), LASTDATE(Table[LastRefreshColumn]), "Last Refresh")

[gp10]

Unfortunatelly @PaulDBrown I cant use the LASTDATE function because my LastRefreshColumn has duplicate dates and I'm getting an error message.

[PaulDBrown · Accepted solution]

Try:
Last Refresh = IF(ISFILTERED(SlicerTable), MAX(Table[LastRefreshColumn]), "Last Refresh")

[gp10]

My bad @PaulDBrown , I should have mentioned that I tried the MAX instead of LASTDATE but it returns this #,0.00 for every selection.
I have tried this with both Date and Date/Time columns and I get the same result.

[gp10 · Accepted solution]

Regarding the  #,0.00 part, I needed to change the measure format from General to Whole or Decimal number.

[PaulDBrown · Accepted solution]

Try:
Last Refresh =
VAR MX = CALCULATE(MAX(Table[LastRefreshColumn]), ALL(Table)
RETURN
IF(ISFILTERED(SlicerTable), MX, "Last Refresh")

[PaulDBrown]

How are you "selecting" a report?

[gp10]

Hi @PaulDBrown ,
by a slicer and a table visual.