Hi @tal,
Seems like you aren’t filtering your data as you want the full dataset in computing the average values that you are comparing with. You can still get dataset wide calcs in a filtered visual through the use of LAC-W calculations in PRE_FILTER mode.
Read more at Using level-aware calculations in Amazon QuickSight - Amazon QuickSight
I’m marking this as solution for now. Please feel free to post with more details if you aren’t able to make it work. In that event, post a sample analysis in Arena to make it easier for community members to help you.
Regards,
Arun Santhosh
Pr Quick Sight SA