topic Re: MEDIANX DAX in DAX Commands and Tips

MEDIANX DAX

Anonymous — Mon, 09 Dec 2019 10:09:17 GMT

I have a problem with getting MEDIANX to function.

I want to change this formular from Average to Median:

GNSpurchase = AVERAGE('GAdata'[purchase])

I'm just not sure what to do from here

I have tried this:

GNSview = CALCULATE(MEDIANX(GAdata;GAdata[Views]))

It tells me something about "a circular dependency was detected" and the output is blanks in every cell.

Hope you can help me. Thx.

Re: MEDIANX DAX

az38 — Mon, 09 Dec 2019 11:19:20 GMT

Hi Anonymous

try without calculate

= MEDIANX(GAdata;GAdata[Views])

do not hesitate to give a kudo to useful posts and mark solutions as solution

Re: MEDIANX DAX

Anonymous — Mon, 09 Dec 2019 11:28:58 GMT

Does not work - unfortunately 😞

When I do that, it says: "Expression that yield variant data type error cannot be used to defined calculated columns".

Re: MEDIANX DAX

az38 — Mon, 09 Dec 2019 11:46:40 GMT

Anonymous

are you sure your Views column is a number? check in the Power Query mode. choose column and set whole or decimal number as data type in the Transform ribbon

and try to create measure, not calculated column

do not hesitate to give a kudo to useful posts and mark solutions as solution

Re: MEDIANX DAX

Anonymous — Mon, 09 Dec 2019 13:24:57 GMT

The View column is definitely a number - without decimals as well.

Can you give an example of measure?

Re: MEDIANX DAX

az38 — Mon, 09 Dec 2019 13:28:49 GMT

Anonymous

the same as column, but measure.

anyway it looks like your data in Views is inconsistent. maybe you have a null values? if so, you should to solve what to do - delete from calculation or change it to 0 (preferrably in Query Editor mode)

do not hesitate to give a kudo to useful posts and mark solutions as solution

Re: MEDIANX DAX

Anonymous — Mon, 09 Dec 2019 14:07:35 GMT

az38

I don't have any null value in the View column. However, I have a lot of zero values. Hmmm....

Re: MEDIANX DAX

az38 — Mon, 09 Dec 2019 16:36:32 GMT

Anonymous you could share your pbix-file to check it out

Re: MEDIANX DAX

Anonymous — Tue, 10 Dec 2019 08:09:22 GMT

az38

Can't see where to share pbix-files... lol. I don't see an upload file function..?

Re: MEDIANX DAX

az38 — Tue, 10 Dec 2019 08:10:41 GMT

Anonymous there is no upload function (only for admin) use for example https://uploadfiles.io/ service

do not hesitate to give a kudo to useful posts and mark solutions as solution

Re: MEDIANX DAX

Anonymous — Tue, 10 Dec 2019 08:23:01 GMT

az38

Ok, cool, thx.

https://ufile.io/9jzeyjpm

Re: MEDIANX DAX

az38 — Tue, 10 Dec 2019 08:28:07 GMT

Anonymous

if you create measure, not calculated column it should work

Measure = MEDIANX(GAdata;GAdata[Views])

do not hesitate to give a kudo to useful posts and mark solutions as solution

Re: MEDIANX DAX

Anonymous — Tue, 10 Dec 2019 08:41:09 GMT

az38

Copied your formular but it is not working - unfortunately.

Thanks for the effort though.

Re: MEDIANX DAX

az38 — Tue, 10 Dec 2019 08:44:08 GMT

Anonymous really?

https://ufile.io/7c10lawz

look at Measure