Option for measures to 'show totals as' with options such as sum, average, median, etc

Hello all,

I have been struggling with incorrect totals in hierarchies while using a measure. I understand this is caused by a lack of context for the 'totals' row. What I don't understand why an incorrect value is shown by default. This is confusing and off-putting, especially for people new to DAX and PBI.

Why don't we add an option similar to 'show values as', call it something like 'show totals/subtotals as' and give options for different aggregations?

I found a way using SUMMARIZE to create a virtual table for SUMX, AVERAGEX and MEDIANX. Confusingly, the first two work fine, while the latter omits filtered values as it pleases. I don't even know whether this way is correct, but it would be very useful to have the correct DAX imbedded.

Thanks guys!

Jana