How to sum and average at same column with different aggregation levels

Hello,

I hope you can help me with this. I'm sure it is quite simple but I don't seem to find the right measure.

I need the create a column in my matrix that creates the sum up of the number of products by store level on year 2022. However when the matrix is grouped by type of store level, it should show the average of the number of products.

I'm using something like:

IF (ISFILTERED (Table [Type of Store] , CALCULATE (AVERAGE (Table [#Products], Table [Year] = "2022") ,

CALCULATE (SUM (Table [#Products], Table [Year] = "2022"))

But this is not working at all, the result is not even a correct average of the number of products.

Expected result shoul be:

Find below the dataset you can use to replicate the situation: