How to calculate 'Other Increases' in a matrix

[Anonymous]

I'm trying to make a table (or matrix) of our top 5 products by change in volume. Here is what I have so far.

Matrix in Power BIWe have about 30 products, and we are showing the Top 5 increases in volume. So in the matrix above, we are showing that we sold about 270k pounds more of Product 1 in May 2019 vs May 2018, and so on. 

However, we would like to show an 'Other Increases' category. The rule is that if the volume change from May 2018 to May 2019 is positive, we want to sum up all the products with positive increases that are not in the top 5. The highlighted row below is a screenshot of what we did it in Excel.

From Excel

The way we did it in Excel was manual, but I was wondering if there is an automatic way to perform this calculation in Power BI.

Thank you all for any help.

[v-lili6-msft · Accepted solution]

HI, @Anonymous 

Here is a same post for you refer to:

https://community.powerbi.com/t5/Desktop/Show-Top-N-and-sum-up-the-Others-as-a-value/m-p/313063#M138849

For your case, just add a conditional that "the volume change from May 2018 to May 2019 is positive" in last formula.

Best Regards,

Lin