Forum Discussion

theopa's avatar
theopa
Frequent Visitor
2 years ago

matrix filter topn and etc

hi all   i want show on a matrix filter with rank top10(value) and etc(remain values sum)   DAX _021Cal_ = IF(NOT(ISBLANK( SUM('Fct_Sales_Domestic'[sales]))),TOTALYTD(CALCULATE(sum(Fct_Sa...
Need Help
amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
2 years ago

theopa , not very clear . But TOPN can be used like

 

FIrst Have measure

YTD= TOTALYTD(CALCULATE(sum(Fct_Sales_Domestic[sales])), D_Calendar_Sales[Date])

 

Top10= Calculate( [YTD], keepfilter(TOPN(10,allselected([Table[Date]), [YTD], asc) ))

 

refer

Learn Power BI: Dynamic TOPN using TOPN/Window and Numeric parameter: https://youtu.be/vm2mdEioQPQ

  • theopa's avatar
    theopa
    Frequent Visitor
    2 years ago

    thank you for reply

     

    i understand that topn topn

    but i need is topn and others

    if i set top3  than not only top3 values but also another values with etc in brand column

    and other columns maybe sum other brands values😂