group data by dimension (aggr function in qlik sense)

Hi, there's no way to say this problem easily..

I have 3 tables:

• POS current month data table (item, location code, datetime, sales amount)
• plan table (location code, latitude,longitude, sales plan)
• location table (location code, latitude,longitude) 

These tables have a relation by location code column: PLAN 1-* POS *-1 LOCATION

Main goal is to show a map chart that displays location code on the map with it's sales plan execution percentage.

In Qlik Sense its super easy, there is a aggr function, that automatically groups by any dimmension:

sum([Sales amount]) / sum(aggr(sum([Sales plan]),[Location code]))

In powerBI Plan table I have added:

(new column) TotalSales = sumx(relatedtable(POS);POS[Sales amount])

(new measue) Execution = sum(Plan[TotalSales]) / sum(Plan[Sales plan])

Abviously now every location shows the same execution percentage, because there is no grouping by location. How to solve this?