Hi all,
Our developer (small time company) is on vacation and since I am not able to do calculated columns myself as we use SSAS cube, I am hoping one of you can help me.
The thing is - I have a Hierarchy in Table 1 containing Continent, Country and City. In Table 2, I have Person ID and Table 3, I have hours registered.
I would like to do a measure (preferably a calculated column, but I am not able to do this, as I don't have access to the SQL server) where I am calculating the following: an Average based on City and an Average compared to the others in the same city. I would LOVE for it to be in the same table / visualization. Is this even doable without any developer having to create a new column for me?
See an example below
| Continent | Country | City | Person ID | Hours registered | AverageBasedonCity | Average compared to group in City |
| Asia | China | Guangzhou | 7 | 6 | 8 | 75,00% |
| Asia | China | Guangzhou | 8 | 10 | 8 | 125,00% |
| EU | Germany | Berlin | 2 | 3 | 4 | 75,00% |
| EU | Germany | Berlin | 4 | 5 | 4 | 125,00% |
| EU | Sweden | Stockholm | 6 | 5 | 5 | 100,00% |
| NA | USA | New York | 1 | 2 | 18 | 11,11% |
| NA | USA | New York | 3 | 4 | 18 | 22,22% |
| NA | USA | New York | 5 | 6 | 18 | 33,33% |
| NA | USA | LA | 40 | 40 | 40 | 100,00% |
| NA | USA | NEw York | 10 | 60 | 18 | 333,33% |
