too many arguments were passed to the MEDIAN function. The maximum argument count for the function 1

[riishabhzz]

Hi Everyone ,

need small help from you .

i am getting below error :-

too many arguments were passed to the MEDIAN function. The maximum argument count for the function is 1.

in excel its working MEDIAN(0,140000,D36-350000) , D36 is having value column which i have used in Dax 

but in pbi dax 

MEDIAN(0,140000,sum(value)-350000)

pl help 🙂

[FreemanZ · Accepted solution]

then try this:

MEDIANX({0,140000,sum([value])-350000}, [Value])

I tried and it works. 

[riishabhzz]

thanks a lot 🙂

[riishabhzz]

[riishabhzz]

hi , 

i tried to do that but getting same error

dont know what i am doing wrong

[FreemanZ]

try this

MEDIAN({0,140000,sum([value])-350000})

[riishabhzz]

Heyy , i have shared screen-snip for your refrence in above trail 🙂