Formula DAX: ALLEXCEPT or ALL not working

Hi everyone, 

I need help with the dax formula I am using, since it does not calculate well when I use ALLEXCEPT or ALL.

Actually I use three variables:

1. Sales

2. Orders

3. Average Sales/Order = Sales / Orders

The orders are at the country and period level; and Sales are at the level of country, period, category, brand, product.

When I calculate the "Average Sales/Orders", Orders must be maintained and only vary according to the country and the period. On the other hand, Sales varies according to the country, period, brand, category, product.

When I made the formula for the Orders, apply ALL or ALLEXCEPT so that it does not filter according to brand, category and product and so it remains constant, but it is not working.

*To take in consideration: not all the countries have all brands, categories and products.

 Thanks,

Sol