Forum Discussion

Anik's avatar
Anik
Helper I
5 years ago
Solved

Wrong calculation

 Here I've encountered a problem. In 2013, the number of sales was 12,760. When I dragged the (country) column into the Columns section, an additional blank row is created. Whatever columns (coun...
Need Help
  • Arentir's avatar
    Arentir
    5 years ago

    Hi Anik ,

    Your Date dimension relates to the delivery date key field in Fact table, and you do have records with blank delivery date in the fact table. This is why the dimdate field is empty, and power bi won't filter them out by default in case you need them!

     

    If you want to avoid that, you could add a filter on the visual/page/report to exclude those cases.

     

     

     

  • Greg_Deckler's avatar
    Greg_Deckler
    5 years ago

    Anik Try using Invoice Date Key instead to form your relationship. You have blanks in your Delivery Date Key.

Greg_Deckler's avatar
Greg_Deckler
Community Champion
5 years ago

Anik There is likely something going wrong in a relationship between two tables. You tend to get blanks when rows don't match up. For example:

 

Year

2013

2014

2015

 

Fact

Year   Value

2012  2

2013  5

2014  6

2015  2

 

Assuming a relationship between the two tables on Year if you used Year from your Year table and a sum of Value from your other table you would get a blank row that is essentially the 2012 data.