Display maximum slicer selected values in a table visual

[Bhanuaripaka]

Hi there! 

I am looking for help with a DAX measure which should display max selected date value slicer in a table visual.  

eg: max transaction date in slicer below is 8/07/2024 , I want that date should be displayed as my invoice date for all my transactions.

Appreciate your help! 

[Bhanuaripaka]

Thank you @Shravan133 . It worked, really apppreciate your help.

[Shravan133 · Accepted solution]

Hi,

Try this:

MaxSelectedDate =
CALCULATE (
MAX ( 'DateTable'[Date] ),
ALLSELECTED ( 'DateTable' )
)

and then, you can create another measure to display the max selected date as the invoice date for all transactions:

InvoiceDate =
VAR MaxDate = [MaxSelectedDate]
RETURN
IF (
NOT ISBLANK ( MaxDate ),
MaxDate,
BLANK ()
)