aseagullHelper IV4 years agoSolvedHelp with VALUES() 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() on...Show MoreVahidDM4 years agoHi aseagull 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!!
VahidDM4 years agoHi aseagull 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!!
VahidDM4 years agoHi aseagull 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!!
VahidDMSuper User4 years agoHi aseagull 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!!
Related contentClosing valueremove duplicate value within a rowIF Negative valueDAX for calculating retroactive valuesHandling Null Values
