Sort Matrix by dynamic column value based on filters

Hi,   I have a requirement to sort a matrix by the last possible month value, 7 in the example below. The issue is that Power BI only sorts by the total and that is not what I want.     I ...