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

     

Anonymous's avatar
Anonymous
Not applicable
3 years ago

Thanks for that. It's giving me a value but it seems to be working it out wrong somewhere.

One column I have in Excel averages out at 5 and the slicer shows 16 but the DAX code above is showing it as 244.23% above when I think it should be 320%?