Hi @Ummehaani and @David_Wong, we just launched the Level-Aware-Calculation feature, now you are able to quickly solve this problem using avg(avg(salary, [customer]))
, this calculation won’t be impacted by other dimensions added to the visual, and will give you the correct total number.
Details please see the following user guide.