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:
The error says that MEDIAN() only accepts a column reference. How do I tell it that the result of VALUES() is a single column?
Go to Solution.
Try to use MEDIANX rather than MEDIAN:
Something like this:
If this post helps, please consider accepting it as the solution to help the other members find it more quickly.
Appreciate your Kudos!!
View solution in original post
Learn how to create your own user groups today!
Click here to read more about the November 2021 Updates!
Join us, in-person, December 7–9 in Las Vegas, for the largest gathering of the Microsoft community in the world.