Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

Median Measure

 

Hi Experts,

I want to create a DAX Measure to show the median value based on the above result. How can I do that?

 Please Help. Thank you.

Need Help
Show and Tell
  • jdbuchanan71's avatar
    jdbuchanan71
    4 years ago

    Anonymous 

    What does MEDIANX give you?

    Median = MEDIANX ( DISTINCT ( Data[Name] ), FIRSTNONBLANK (Data[Value], 0 ) )

1 Reply

  • jdbuchanan71's avatar
    jdbuchanan71
    Icon for Super User rankSuper User
    4 years ago

    Anonymous 

    What does MEDIANX give you?

    Median = MEDIANX ( DISTINCT ( Data[Name] ), FIRSTNONBLANK (Data[Value], 0 ) )