FORMULA ISSUE WITH ENDING VALUE

[rwong1]

Hi,

I have an issue.  I created a measure to get the ending revenue figure based on year selected but it is showing a strange revenue figure instead of displaying 2022's revenue which should be $26,695,391.35.  I'm not sure what I'm doing wrong.  The formula I'm using in my Ending Year Value measure is: 

Ending Year Value = CALCULATE([Actual Revenue],FILTER(ALL('Revenue Table'[Year]),'Revenue Table'[Year]=[LastYear]))

The formula I'm using for LastYear measure is:

LastYear =

LASTNONBLANK (

    ALL ( 'Year Table'[Year]),

    [Actual Revenue]

)

See the image below:

[Ashish_Mathur]

Hi,

If you want to show the revenue of the selected year, then just drag the actual revenue measure to the card visual.