2 Replies Latest reply on Apr 16, 2018 1:23 PM by ShivaRam Chennapragada

    Cannot blend the data source because one or more fields uses an unsupported aggregation- Problems with Calculating Median

    jacob.armington.0

      Hi Everyone,

       

      I have two separate data sources with two separate worksheets and I've applied a common filter on both. They both share a common field (State), and that is what I'm filtering on. When I calculate the average of a measure and use the filter, it works perfectly fine. The problem is when I try to calculate the median of that same measure. I receive this error: "Cannot blend the data source because one or more fields uses an unsupported aggregation". I can calculate the average, so it seems strange that I wouldn't be able to calculate the median. Any ideas on how to get the median? Thank you in advance!