Forum Discussion
Formula to sort by accuracy (absolute error)
Hello everyone, I need some help. Any advice will be appreciated, especially if someone can explain. I have such a visualization. I need to sort by lowest forecast accuracy. ...
Anonymous Why not something using absolute value? Like:
Error = ABS([Accuracy] - 1)
Anonymous Thank you very much. But the first step is how to basically let PowerBI know that 100.01 accuracy and 99.99 accuracy is basically a mistake of 0.01 so that it is treated as the same mistake? That is the biggest issue for me. I don't understand how it can be done.
Anonymous Why not something using absolute value? Like:
Error = ABS([Accuracy] - 1)