Show top 10 results

[Johan-MTM]

Hi,

I would like to show only the top 10 results but I can't figure out how, any help would be much appriciated!

[Johan-MTM]

Thank you @amitchandak! I wassn't able to find the Top N filter option untill i watched the video you linked to. 

[amitchandak · Accepted solution]

@Johan-MTM , You can use TOPN in visual level filter, or can create TOPN measure

example

TOP2 Brand = CALCULATE([Net], TOPN(2,ALLSELECTED('Item'[Brand]), [Net],DESC), values('Item'[Brand]))

TOP2 Category = CALCULATE([Net], TOPN(2,ALLSELECTED('Item'[Category]), [Net],DESC), values('Item'[Category]))

on 2 columns

2 column top N = CALCULATE([Net], TOPN(10, SUMMARIZE(ALLSELECTED('Item'), 'Item'[Brand], 'Item'[Category]), [Net],DESC),VALUES('Item'[Brand]), VALUES('Item'[Category]) )

refer TOPN: https://youtu.be/QIVEFp-QiOk