Forum Discussion

procyon82's avatar
procyon82
Icon for Resolver I rankResolver I
10 years ago
Solved

Removing Outliers

Is there an easy way to remove any outliers in Power BI desktop?

I am currently importing revenue from Google Analytics, but every now and then we get very large purchases that scew the averages. Could I simply apply a filter and say "avg. revenue only on the values that are under $5000"? Or maybe use a standard deviation function that we'll do this automatically for me?

Need Help

8 Replies

  • Greg_Deckler's avatar
    Greg_Deckler
    Icon for Community Champion rankCommunity Champion
    10 years ago

    In the Query Editor, make sure that the column is numeric and then click on the drop down arrow in the column header and choose "Number Filters" and there you have a choice of:

     

    Equals

    Does not equal

    Greater than

    Greater than or equal to

    Less than

    Less than or equal to

    Between

    • procyon82's avatar
      procyon82
      Icon for Resolver I rankResolver I
      10 years ago

      I guess the only downside with this is that it filters the entire query and all the columns/measures that I have. Is there a way to only apply it to a column or measure?

      • Greg_Deckler's avatar
        Greg_Deckler
        Icon for Community Champion rankCommunity Champion
        10 years ago

        Yes, for that you would use a CALCULATE function (DAX). Basically:

         

        CALCULATE(SUM([Some Column]),[Some Column] < 500000)