Forum Discussion

ade_kurniawan's avatar
ade_kurniawan
Frequent Visitor
5 years ago
Solved

Show Top N Rank Category

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_...
DAX Commands and Tips
  • CNENFRNL's avatar
    CNENFRNL
    5 years ago

     

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

     

CNENFRNL's avatar
CNENFRNL
Icon for Community Champion rankCommunity Champion
5 years ago

 

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

 

ade_kurniawan's avatar
ade_kurniawan
Frequent Visitor
4 years ago

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