Forum Discussion

DebbieE's avatar
DebbieE
Icon for Community Champion rankCommunity Champion
7 years ago
Solved

Power BI Using Adventurers DD in Azure DimGeography not working

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

2 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable

    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's avatar
      DebbieE
      Icon for Community Champion rankCommunity Champion

      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