Forum Discussion

stevezly's avatar
stevezly
Icon for Helper I rankHelper I
4 years ago
Solved

Median giving incorrect values

Hi All,    I am trying to calculate median over some grouped data, but the "median" value I get back is the same for each group which cannot be correct. Am I missing something here?   Thanks   ...
Need Help
  • johnt75's avatar
    johnt75
    4 years ago

    It would be returning the median across the entire dataset, it wouldn't be split into any categories.

johnt75's avatar
johnt75
Icon for Super User rankSuper User
4 years ago

You need to wrap the MEDIAN call inside CALCULATE() so that it picks up the row context from the SUMMARIZE.

  • stevezly's avatar
    stevezly
    Icon for Helper I rankHelper I
    4 years ago

    Ah thanks, was being silly. 

     

    It is strange though. The values I am getting for "Median" do not match up with  spot checked values from the main Median measure, when i filter down into these groups.