Help with finding a median and weighted average given two columns

[DEFresh3451]

Hello

I am a n00b here, so bear with me. I have a data set where I am trying to find multiple median values, and then want to find the weighted average of those medians.

Here is a sample data set:

I am trying to find a median of Total for each of the Group A and Group B combos: AC, BC, AD, BD. My Data set has a large number of combos, so I am looking for something dynamic.

Part 2 would be to then take the medians I just found, and perform a weighted average. 

Is there a way to do this?

[djurecicK2 · Accepted solution]

@DEFresh3451 Here is a way you can do this. 

Create a new column which combines Group A and Group B

Then create a table that gets the median value per combo group:

Group Medians = SUMMARIZE(Groups,Groups[GroupCombo],"Median",MEDIAN(Groups[Total]))

Not sure what you mean by weighted average of medians- can you please explain further or post an example of the desired result?

[DEFresh3451]

Thank you!!!