Forum Discussion
Anik
Helper I
Helper IWrong 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...
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.
Anik Try using Invoice Date Key instead to form your relationship. You have blanks in your Delivery Date Key.
Greg_Deckler
Community Champion
Community ChampionAnik Try using Invoice Date Key instead to form your relationship. You have blanks in your Delivery Date Key.
AnikHelper I
Helper IHi Greg_Deckler , Arentir , thank you so much 😊. Next time I am going to keep in mind about the blank cells while making relationships.