Top 10 values for matrix with measure as value

[DoreBotha]

Hi

I'm a fairly new user.

I am trying to show the Top 10 sites, based on the average month-on-month growth, in a matrix visual. I have sites as the rows, month as the column and a measure calculating the month on month growth as the values.

The DAX for my measure is:

% MoM Diff =

    DIVIDE(SUM('Raw Data'[Sales QuantityBase Unit]) - CALCULATE(SUM('Raw Data'[Sales QuantityBase Unit]),PREVIOUSMONTH('Raw Data'[Month])),

        CALCULATE(SUM('Raw Data'[Sales QuantityBase Unit]),PREVIOUSMONTH('Raw Data'[Month])))

If I use the raw sales (Sales QuantityBase Unit) as the values, not the month-on-month measure, I can use the filters for the visual to show the top 10 like below

However, the option to choose sum/average/min etc. is not available if I use the measure as the values. When I apply the filter as is

is just shows a blank matrix.

What is the easiest way to fix this?

Thanks!

[amitchandak]

@DoreBotha , Based on what I got.

Best to use a measure or it will take the default Aggregation of the column.

[DoreBotha]

Hi @amitchandak 

Thanks for your reply!

How do I then use the measure to get the Top 10?

The problem is it doens't give me the option on the filters pane.