2 Replies Latest reply on Jun 9, 2016 6:41 PM by Ivan Young

    Aggregate Arguments

    Zhe Wang

      I have a list of "Sale" data. I want to calculate the difference between every sale entry and the average sale.

      Then I add a calculated field Average Sales:

      AVG(Sale)

      it should be an aggregate value.

      I continue to create another calculation

      Sale-[Average Sales].

      Of course it is false cause it mixes aggregate and non-aggregate arguments.

      I try to aggregate [Sale], but ATTR[Sale] is not suitable cause there may be duplicate values in Sale.

      Other measures are not exactly meet my demands like SUM.

      I just want to calculate the difference for every entry just as what we can do in R or Python.

      Is there any alternatives?