Min value in each group that is affected by filters

[EVS5005]

Hello, I'm trying to get the max value in a group but still have it be affected by filters. 

For example, I have a table that looks like this and I want to return the maximum value of transaction source for each client

Client	Transaction Date	Transaction Source
Client A	2024-09-01	In store
Client A	2024-10-01	Online
Client A	2024-11-01	In store
Client B	2024-10-01	In Store
Client B	2024-11-01	In Store

The result should be the following if there is no filter applied

Client	Max Transaction Source
Client A	Online
Client B	In Store

and I want the result to be the following if there is a filter on Transaction Date = 2024-11-01

Client	Max Transaction Source
Client A	In Store
Client B	In Store

I've tried using 

max transaction source = calculate(max(Overview[Transaction Source]), filter(allselected(Overview), Overview[client] = SELECTEDVALUE(Overview[client])))
but it returns blank

and

max transaction source= calculate(max(Overview[Transaction Source]), allexcept(Overview[client])) 
but it isn't filterable. 

[parry2k · Accepted solution]

@EVS5005 

Max = 
CALCULATE (
    MAX ( 'Table'[Transaction Source] ),
    TOPN (
        1, 
        FILTER ( 
            ALLSELECTED ( 'Table' ),
            'Table'[Client] = MAX ( 'Table'[Client] )
        ),
        'Table'[Transaction Source],
        DESC
    )
)

[parry2k]

@EVS5005 add DESC

Max = 
CALCULATE (
    MAX ( 'Table'[Transaction Source] ),
    TOPN (
        1, 
        ALLSELECTED ( 'Table' ),
        'Table'[Transaction Date],
        DESC
    ),
        VALUES ( 'Table'[Client] )
)

 but still not sure why you are getting Online for Client A when no filter is applied  

[EVS5005]

Online is the max value between Online and In Store, so if both exist the output would be Online. 
This also doesn't work, its just taking the max value of everything and not grouping it by the client. It also doesn't change when I apply a filter on transaction date

[parry2k]

The solution was based on the assumption that you are taking most recent transaction. Change the date column to source column 

[EVS5005]

This kinda works for A, but since B doesn't have an "Online" value its being removed 

[parry2k]

@EVS5005 you are not explaining why you are getting online for client A, what is the logic behind it?

[parry2k]

@EVS5005 it should work, share the sample data. in you original post this output is wrong, for client A it should be "in store" because the max date is 2024-11-01, not sure how you came up with online

Client	Max Transaction Source
Client A	Online
Client B	In Store

[EVS5005]

and I want the result to be the following if there is no filter applied

Client	Max Transaction Source
Client A	Online
Client B	In Store

and I want the result to be the following if there is a filter on Transaction Date = 2024-11-01

Client	Max Transaction Source
Client A	In Store
Client B	In Store

[parry2k]

@EVS5005 try this dax measure:

Max = 
CALCULATE (
    MAX ( 'Table'[Transaction Source] ),
    TOPN (
        1, 
        ALLSELECTED ( 'Table' ),
        'Table'[Transaction Date]
    ),
        VALUES ( 'Table'[Client] )
)

[EVS5005]

This doesn't work either, it just returns Online for everything