0
Median with SQL Server direct query
How can I get the median for a measure with a SQL Server data source using direct query? Median is not in the list of aggregate functions for a measure. If I try to create a formulate using Median, I get the error "The aggregation MEDIAN is not supported in data source of type SqlServer". It is available as a context calculation but I need it to be calculated at the model level.