Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago
Solved

Check if sliced value is higher than total average value

Hi all,   I'm probably going to make this sound more complicated than it is but what I'm looking to do is see if the slicer value is higher or lower than the average of a column.   For example: ...
Need Help
  • grantsamborn's avatar
    grantsamborn
    3 years ago

    Hi Anonymous 

     

    I imported that data and set up the following example based on New Applications.

     

    Let me know if you still have the same problem.  If so, please show your expected results for New Applications by Store.

     

    pbix: Pct above Avg 1.pbix

     

grantsamborn's avatar
grantsamborn
Icon for Solution Sage rankSolution Sage
3 years ago

Hi Anonymous 

 

I imported that data and set up the following example based on New Applications.

 

Let me know if you still have the same problem.  If so, please show your expected results for New Applications by Store.

 

pbix: Pct above Avg 1.pbix

 

Anonymous's avatar
Anonymous
Not applicable
3 years ago

That seems to have done it! Thank you for that.

The only thing I can't seem to do now is do the same for a measure I created called AOV (Average order value) that divides the full accepts £ by the full accepts.

  • grantsamborn's avatar
    grantsamborn
    Icon for Solution Sage rankSolution Sage
    3 years ago

    Would this help?

    AOV = 
    DIVIDE(
        SUM( 'DataTable'[Total (Full) Accepts Amt] ),
        SUM( 'DataTable'[Total (Full) Accepts] )
    )