Filter based on multiple criteria

[Anonymous]

Hi There, I have some sample data liks the below :

Year   Revenue   Type

2015  5758         Actual

2016  9854         Actual

2017  7557         Actual

2018   4983        Actual

2019    9435       Projected

I only want to select the revenue of the max year where type = 'Actual' i.e. 4983 of year 2018

How can I do this ? Apreciate your assistance and time.

[Nathaniel_C · Accepted solution]

Hi @Anonymous ,

Last Year Revenue =
VAR _maxYear =
    CALCULATE ( MAX ( Rev[Year] ), FILTER ( ALL ( Rev ), Rev[Type] = "Actual" ) )
VAR _Revenue1 =
    CALCULATE ( MAX ( Rev[Revenue] ), FILTER ( Rev, MAX ( Rev[Year] ) = _maxYear ) )
RETURN
    _Revenue1

Let me know if you have any questions.

If this solves your issues, please mark it as the solution, so that others can find it easily. Kudos are nice too.
Nathaniel