Show only Top N rows

[Lucas-128]

Hey everyone.

Im having trouble displaying the top (or bottom) N rows based in sales in my matrix visual.

I cant do any modifications on the model so the solution has to be frontend.

Example table: product, category and sales.

A product can have more than 1 category, therefore it has multiple entries. 

When I use Top N filter on product by sales, I end up with the following table.

The filter is working correctly but rather than seeing all the rows where any of the Top 2 appear,

I need to only see the 2 rows with the top (or bottom) sales.

Expected result: 

Any way to achieve this?

Thanks in advance.

[amitchandak]

@Lucas-128 , Create a measure

M1= calculate(Sum(Table[Value]) , allexcept(Table, Table[product]))

or

M2 = calculate(Sum(Table[Value]) , filter(allselected(Table) , Table[product] = max(Table[product])  ))

measure = sum(Table[Value])

use this in TOPN

CALCULATE( [Measure] ,TOPN(3,allselected('Table'[Product]), [M1] ,DESC),values('Table'[Product]))

[Lucas-128 · Accepted solution]

It didnt work! I was able to resolve it by getting access to the model and creating another column 

Thanks anyways 🙂