Sort Matrix By Desc of Last date

[Mokegubshook]

I have matrix looklike in picture, where each Application have multiple ID and Status. Is it posible to sort Desc of number of usage by last date. For example, If 6 Jan is last date sort by number of usage Desc of 6 Jan that should be App B ID 003 status zzz yyy xxx is top  row follow by other status.

[bhanu_gautam · Accepted solution]

@Mokegubshook Create a measure to find the last date in your dataset.

LastDate = MAX('YourTable'[DateColumn])

Create another measure to calculate the number of usages on the last date. You can use the following DAX formula:

UsageOnLastDate =
CALCULATE(
SUM('YourTable'[UsageColumn]),
'YourTable'[DateColumn] = [LastDate]
)

Add the necessary fields (App, ID, Status1, Status2, Status3, etc.) to your matrix visual.
Add the UsageOnLastDate measure to the values section of the matrix.
Sort the matrix by the UsageOnLastDate measure in descending order.

[Mokegubshook]

Your solution is working! 

I have one more question, I also have month filter. I want to show the highest usage in the month I selected. I have no idea to combine with your measure. Is it possible?

Thank You so much!