Replace empty cells with 0 matrix power bi

[Pvargash]

Hello community, help me with the following, I have the known problem of being able to replace empty cells with 0, I tried this first part using Coalpace and also Blank(), the problem with that is that in the categories and subcategories according to my model of data, values ​​with 0 appear in all categories (Unidad de Negocio) and subcategories (Nomcat) even if there is no Sales record for those categories, I only need to complete with 0 those cells that have at least had movements greater than 0 in any of the weeks.

I currently have sales only until the year 2022, until week 33

but when I add the formula to replace Empty with 0 the following happens to me, the other categories and subcategories are added and every week up to 53

GP =

VAR Total_GP = CALCULATE([Total_GP])

return

--Total_GP

IF (

Total_GP = BLANK(),

0,

Total_GP

)

This is my data model

[Pvargash]

Thanks MahyarTF for the answer,

I have modified the formula, the number of weeks for 2022 is correct and it shows the values ​​but I still have gaps, in the weeks for certain categories and subcategories, those should be painted with 0

Now if I make the following change to the formula,

GP =

VAR Total_GP = CALCULATE([Total_GP])

return

--Total_GP

IF(

Not(isBlank(Total_GP)),

Total_GP,

0

)

it shows 0 for all the weeks which is correct, but it adds all the categories and subcategories that have not been sold and also adds all the weeks. I think there is a filter missing that indicates that I only need to limit sales of the current year and only of the weeks that I have to date, but I don't know how to do it

[MahyarTF]

Would you please share a sample PBIX file with me here.

[MahyarTF]

Hi,

Not sure, but maybe it is because you check the Blank value and replace it with 0.

Check the below script instead of yours :

GP =

VAR Total_GP = CALCULATE([Total_GP])

return

--Total_GP

IF (

Not(isBlank(Total_GP)),

Total_GP

)