DAX(Add column) - MAX function with Filter

[ngct1112]

Hi all, I am trying to add a DAX column to find out the MAX value among few columns, meanwhile, less then the baseline value.

Baseline	A	B	C		MAX_R
10	7	9	12		9
13	10	12	11		12
15	14	18	20		14
19	17	13	25		17

Line 1 in the MAX column, "9" is the largest value among A, B ,C and <10

I am trying this formula but not success. May I have some advice?

MAX_R = 
VAR _list = {
    ('table'[A]),
    ('table'[B]),
    ('table'[C])}
return
MAXX(FILTER(_list.[value]<'table'[Baseline]))

[amitchandak · Accepted solution]

@ngct1112 , Test as

Column MAX_R = 
maxx(Filter(Union(Row("A",'Table'[A]),Row("A",'Table'[B]),Row("A",'Table'[C])),[A] <=[Baseline]),[A])

[ngct1112]

@amitchandak Thanks so much for your soluction which is working in my model!