SumOver -Summing distinct entries from a table with duplicate rows

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.