Total by sku line & Total by sku product group

[ajaydavidluke]

Hi, 

I am attempting a dax formula which would give me total order qty by SKU but also combining all SKU relevant to that prouct group (product/Colour).  Below is what we get when we have filters on this particular visual but I would like a measure to work this out rather than a filter.

Below is the current dax to work out 2019 actual order qty but is only working due to the filters........We then need to work out the total for the Product/Colour and then work out a % of the SKU order qty figure against the total by product/colour figure without filters:

2019 Actuals =

CALCULATE(

sum('Source Orders'[Ordered Qty]),

filter(all('Calendar DAX'),VALUE('Calendar DAX'[Year])=2019)

)

Any help would be much appriciated, I've attempted numerous ways but to no avail 😞  

[Anonymous]

What's the model?