Power BI Using Adventurers DD in Azure DimGeography not working

[DebbieE]

Im using the Adventureworks Data Warehouse as a test in Azure and Im trying to create a Map

We have DimGeography joined to DImSalesTerritory and and FactResellerSales joined to DimSalesTerritory

This is at individualsale level so If I choose city in Dim Geography Id imagine it wouldwe ok but its not. For example:

If you drag in City from DImGeography and SalesAmount from FactResellerSales into a table. Each City has exactly the same sales amount against it which isnt right

I tried adding Country from the middle Table DImSalesTerritory but this has made no difference.

United Stated Albeny      $53,607,801

United Stated Alhambra $53,607,801

United Stated Alpine       $53,607,801

United Stated Ballard       $53,607,801

etc

I dont understand how this is happening and all the join ID's seem fine between these three tables.

Is there anything that I could be missing. I really wanted to use city against sales amount

[v-shex-msft · Accepted solution]

Hi @DebbieE,

It seems like your relationship not mapping correctly so power bi summarize all records to a static value.

Can you please share some sample data and relationship map?

How to Get Your Question Answered Quickly

Regards,

Xiaoxin Sheng

[DebbieE]

Your right, the Geography dimension isnt mapped correctly to the fact table in Adventureworks (Which is odd because this is the sample data warehouse)

I wasn thinking that Power BI couldnt cope with looking at data from a fact table and a snowflaked table but I think this isnt the case so its the data set and not Power BI