I am not sure how to go about this. The table is named Table, with two columns, Category and Rating. If my data was:
SimpleMedian = Calculate(Median(Table.Rating)) The SimpleMedian here is 3. Easy.
Instead I have for Data:
SimpleSum = Calculate(SUM(table.Rating)) which gives me the values below:
The median of that result is 16, but how do I create the measure(s) to get that result? Median likes columns, not measures...
Ultimately, for a function that requires a column, How do I get it to work with a calculated aggregate measure instead?