Create measure % of sales sum

[Jcolvile]

Hey All,

Here is the issue I have a query which contains the Stock Sku grouped by the Year, Quater displaying the Qty. Sold and Qty. Returned for these periods. Example below:

I need to create a visual which can display as the following:

Doing the totals in the visual is easy, however when it comes to doing the percentage I am stumped. I can work out how to do the % for the sum of all the skus but not break it down individually. Any advice on how to resolve this issue? 

[Sean · Accepted solution]

@Jcolvile This should work!

% Returned = DIVIDE(SUM('Table'[Qty. Returned]), SUM('Table'[Qty. Sold]), 0)

[Jcolvile]

@Sean

Thanks a tonne!