Remove the SKU with blank value when applying the summarize dax to create a new table

[naoyixue1]

Hey there,

I created a table pulling the SKU and related sales occurred in 2022 and 2023 from the sales fact table. But I saw some SKUs there with blank value, which doesn't have any sales in 2022 and 2023. ( the fact table is for all sales from 2020 thru 2023). Is there any way for me to take out those SKUs with blank value when applying summarize to create the new table. 

I already applied the filter to remove the sales which is 0, but still see those SKUs there with blank value.  Any thoughts? 

Thanks!

[Anonymous · Accepted solution]

Hi @naoyixue1 ,

You can add a filter to package your summarise function to filter the 'demand' column which equal to blank or whitespace characters.

Regards,

Xiaoxin Sheng