Data Modelling and Filtering (Basic Tutorial/ Noob)

[Hanx]

Context: A simple flat file (csv) from a youtube tutorial. I thought If I can apply the star schema , would it work or is it overkill?

Here is the schema

When I make a simple matrix table to check, there is this 681K that is fixed regardless of any filters?

The sum total (not shown) is correct but the 681K not being correctly summed to the locations

Im Making a Star Schema but when I apply filter, it shows Sum of Sales with Blank and with the Country.
How do I fix the Blank, is my model correct?

I have double checked in power query and removed all blank rows. Also since the order date was not continous, I made a calendar that has continous dates.

[Anonymous · Accepted solution]

Hi  @Hanx ,

If your relationship tables contains records who can't correctly mapping to related table, it will show blank on Visual or slicer, this blank indicates the missing data.

This is the related document, you can view this content:

Solved: Blanks appearing in visuals - Microsoft Fabric Community

Solved: Seeing BLANKS in Slicer even though there are no B... - Microsoft Fabric Community

Solved: How to handle blank values in visuals - Microsoft Fabric Community

Best Regards,

Liu Yang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[amitchandak]

@Hanx , Seem like there missing data in Dimesion Geography(Get all data) or there are null/blank keys in sales for GeoID. 

Once you remove that issue, it should work

[Hanx]

@amitchandak Thank you for the quick reply

I have tried this with all of my tables in power query column by column via right click and then remove blank rows
Still the same

Is there any alternative way or any M query script that can be applied?

[Hanx]

The Flatfile directly uploaded works well but not the star schema