Forum Discussion

Icon for Helper I rank

Helper 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

SummTable =

ADDCOLUMNS(

SUMMARIZE(pack_et,

pack_stimuli[stimuli_country],

pack_stimuli[stimuli_category],

pack_et[zone],

pack_projects[year],

pack_stimuli[stimuli_region],

pack_stimuli[stimuli_design]), "Median", MEDIAN(pack_et[avg(seen)]

)

)

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

16 Replies

johnt75
Super User
4 years ago
It would be returning the median across the entire dataset, it wouldn't be split into any categories.
- stevezly
  Helper I
  4 years ago
  Thanks John.
  
  Is there anyway I could get these to match up do you think?
  
  Basically I'm having to use a summary column in order to bypass RLS and create benchmarks, but I can't think of a way to calculate median in a way that would tie up with the rest of the report.
  
  Thanks for your help so far
  - johnt75
    Super User
    4 years ago
    If you add the CALCULATE then the summary table should be correct, with the correct median per category.
johnt75
Super 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
  Helper 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.

Related content