No Filter options/results on SUM Measure

[Dawn85]

I am very new to Power BI so I am not sure how to phrase this. I am trying so Sum an entire column with some filters however for some reason it is only showing 2 out of the over 10 Warehouses I should be able to select. There is data in those warehouses but I have no idea where to even start figuring out why they are not showing up.

Any help would be greatly appreciated!

[Dawn85]

A seperate Table worked perfectly. Thank you! 🙂

[AllisonKennedy · Accepted solution]

@Dawn85  It looks like the Value of Parts is null/empty, therefore not showing up in the filter as it would result in a blank graph. 

You may want to create a Warehouse table that lists all the warehouses - then use that in the filters and visuals to ensure all Warehouses show up even if the value is null. 

https://excelwithallison.blogspot.com/2020/08/its-complicated-relationships-in-power.html - info on dimension tables, which is what the Warehouse table would be.

Otherwise you can click 'Transform Data' to open Power Query. Then click 'Transform Column' tab and select the Value of Parts column. Then click 'Replace Values' and replace null with 0 in the Value of Parts column. Careful doing this and make sure that's actually what you want, null and 0 are NOT the same thing.