Dont include row value in total

[DaveCor]

Hi folks, 

I have to be honest, this has me beaten so I'm really hoping someone here has an idea how to do this

Samples table of raw data placed into a single table here for ease of reading

Product	2019 Returns	2019 Sales	2020 Returns	2020 Sales
Apples	59	14556	51	12965
Oranges	334	634858	200	397835
Bananas	34	137014	21	102334
Grapes	125	1270420	119	825232
Total	549	2056848	388	1338366

I have the following measure

Returns = 1000000 * DISTINCTCOUNT(returns_table[source_system_id])/SUM(Sales_table[delivery_qty])

The above gives me a rate per million of returns. From that I created the following

Returns LY = CALCULATE([Returns],DATEADD('Calendar'[Date],-1,YEAR))

Returns YTD = TOTALYTD([Returns],'Calendar'[Date])

Returns Ratio YoY = [Returns YTD]/[Returns LY]

Returns LY Total = CALCULATE([Returns LY], ALL(Product Table[product_family]))

Returns YTD Total = CALCULATE([Returns YTD], ALL(Product Table[product_family]))

In a matrix table this gives me a table showing my products and the "return rate" for each and also the overall return rate for the year

Product	Return YTD	Return LY	Return Ratio	Return YTD Total	Return LY Total
Apples	4053	3934	0.97	267	290
Oranges	526	503	0.96	267	290
Bananas	248	204	0.83	267	290
Grapes	98	144	1.47	267	290
Total	267	290	1.09	267	290

Here is where I am stuck. What I want to do is create an adjusted set of figures whereby the the figures for each product are removed from the YTD & LY totals allowing me to get an adjusted ratio i.e. the overal total with that product excluded from the total. From the table above it would look something like this. 

So the "Adjusted Return YTD Total" for Apples would be the total return rate of all other products excluding Apples. The same then for "Adjusted Return LY Total". 

Product	Return YTD	Return LY	Return Ratio	Return YTD Total	Return LY Total	Adjusted Ratio	Adjusted Return YTD Total	Adjusted Return LY Total
Apples	4053	3934	0.97	267	290
Oranges	526	503	0.96	267	290
Bananas	248	205	0.83	267	290
Grapes	98	144	1.47	267	290
Total	267	290	1.09	267	290

I'm guessing the adjusted ratio would then be a simple measure like this

Adjusted Return Ratio = [Adjusted Returns YTD]/[Adjusted Returns LY]

[Greg_Deckler]

@DaveCor This looks like a measure totals problem. Very common. See my post about it here: https://community.powerbi.com/t5/DAX-Commands-and-Tips/Dealing-with-Measure-Totals/td-p/63376

Also, this Quick Measure, Measure Totals, The Final Word should get you what you need:
https://community.powerbi.com/t5/Quick-Measures-Gallery/Measure-Totals-The-Final-Word/m-p/547907