topic Re: too many arguments were passed to the MEDIAN function. The maximum argument count for the function 1 in DAX Commands and Tips

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

riishabhzz — Fri, 18 Nov 2022 14:09:22 GMT

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 — Fri, 18 Nov 2022 14:49:00 GMT

try this

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

riishabhzz — Fri, 18 Nov 2022 15:57:19 GMT

hi ,

i tried to do that but getting same error

dont know what i am doing wrong

riishabhzz — Fri, 18 Nov 2022 15:59:49 GMT

riishabhzz — Fri, 18 Nov 2022 17:59:28 GMT

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

FreemanZ — Sat, 19 Nov 2022 00:31:32 GMT

then try this:

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

I tried and it works.

riishabhzz — Sun, 20 Nov 2022 09:32:16 GMT

thanks a lot 🙂