topic Help with VALUES() in DAX Commands and Tips

Help with VALUES()

aseagull — Thu, 21 Oct 2021 21:45:10 GMT

I am still very green in DAX. I simply want to find the median value of the distinct elements in a column. I tried to write this:

MEDIAN(VALUES(Table[Column]))

The error says that MEDIAN() only accepts a column reference. How do I tell it that the result of VALUES() is a single column?

Thanks,

Amon

VahidDM — Thu, 21 Oct 2021 22:03:30 GMT

Try to use MEDIANX rather than MEDIAN:

Something like this:

MEDIANX(VALUES(Table[Column]),Table[Column]))

If this post helps, please consider accepting it as the solution to help the other members find it more quickly.

Appreciate your Kudos!!