Sort a matrix column dynamically based on totals

Hi Anonymous ，

Create the following columns:

in Purchase table:

Total sum = SUMX(FILTER('Purchase','Purchase'[Product ID]=EARLIER(Purchase[Product ID])),'Purchase'[Amount])

In product table:

Value = 
LOOKUPVALUE('Purchase'[Total sum],'Purchase'[Product ID],'Product'[Product ID],0)

Rank = RANKX(GROUPBY('Product','Product'[Product Group]),SUMX(FILTER('Product','Product'[Product Group]=EARLIER('Product'[Product Group])),'Product'[Value]),,DESC,Dense)

_Product Group = 'Product'[Product Group]

And select column "_Product Group">sort by Rank:

Then in the matrix,put columns "__Product Group" and "Rank" in the columns field:

Finally you will see:

For the related .pbix file,pls see attached.

Best Regards,
Kelly

Did I answer your question? Mark my post as a solution!