Filtering a Matrix with grouped rows

[DoctorYSG]

If you look at the enclosed screenshot , You will see that I am tring get the matrix to show the top 100 or so Applications by usage time. The issue is that there is a secondary grouping on applicaiton which is version. So it is actually filtering out rows if the any over the versions are under 100 in usage time. (I don't have a ranking, so I just used the usage time).

How would you go about getting the top applications filtered by usage.

a) create a ranking calculated field, for each application with DAX?, and then filter on that?

b) create a new summary table
c) something else?

The source consists of a table of applicaitons, (dimension) and a linked fact table which has usage and other stats associated with the application.

[VijayP · Accepted solution]

@DoctorYSG 

Ranking should solve the problem