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.  

Reply

null

Content aside

  • 3 days agoLast active
  • 6Views
  • 1 Following