Latest value of slicer in a table

[RK_JOB]

Hello,

I am struggling to show the latest value from the slicer in a table. Here is my formula, which works fine if I have a card.

Display Value = 
VAR _month =
    MAX ( 'Wage Inflation DATE'[YearMonth] )
RETURN
    CALCULATE (
        SELECTEDVALUE ( 'Wage Inflation DATE'[YearMonth] ),
        ( 'Wage Inflation DATE'[YearMonth] = _month )
    )

But I want to show in the table as the latest value selected. so instead of 202207, I want to see 202209.

PBIX: https://drive.google.com/file/d/1U3ztyzqCtP1JuM8G3bRqhJNZBfPFz4Vo/view?usp=share_link

Thanks in advance,

EZ

[RK_JOB]

'thanks. Both the solutions work.

[Ashish_Mathur]

You are welcome.

[Ashish_Mathur · Accepted solution]

Hi,

I just changed the cross filter direction to single.  See image.

[amitchandak]

@RK_JOB , You need to create a new measure and use that in the visual or visual level filter

Display Value =
VAR _month =
MAXX (allselected('Wage Inflation DATE'), 'Wage Inflation DATE'[YearMonth] )
RETURN
CALCULATE (
Count ( 'Wage Inflation DATE'[YearMonth] ),
filter('Wage Inflation DATE', 'Wage Inflation DATE'[YearMonth] = _month )
)