matrix filter topn and etc

[theopa]

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_Sales_Domestic[sales])), D_Calendar_Sales[Date])/1000000,0)

[miTutorials]

Watch the below tutorial to display Top N and others in the Visual.

Display Top 3 Products and group others products in PowerBI using DAX | MiTutorials - YouTube

Regards

Ismail

[amitchandak]

@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]

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😂