Show Top N Rank Category

[ade_kurniawan]

Dear friends,

I want to rank descending some data, then i can flag the category by get the top 2 biggest sub category.

i attach my PBIX here : https://1drv.ms/u/s!AhkGQiSs1aWEo3TBgvcNe_DiqS9r?e=pHEN9w 

thanks for help

[CNENFRNL · Accepted solution]

TOP 2 = 
CONCATENATEX(
    TOPN( 2, Sheet1, CALCULATE( SUM( Sheet1[value] ) ) ),
    Sheet1[category],
    ", "
)

[ade_kurniawan]

Sir, would you like to send me pbix file please ? thanks

[CNENFRNL]

Pls refert to the attached pbix file below.

[amitchandak]

@ade_kurniawan , Create Rank in one of the manner and use visual level filter to filter Rank<=2

Cat Rank  = Rankx(allselected(Table[Category]), calculate(sum(Table[Value])),,desc)

You can also refer this

https://www.sqlbi.com/articles/filtering-the-top-3-products-for-each-category-in-power-bi/

Cat Rank = Rankx(filter(allselected(Table[City],Table[Category]) [City] = Max([City])) , calculate(sum(Table[Value])),,desc)