Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
hi all
i want show on a matrix
filter with rank top10(value) and etc(remain values sum)
DAX
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
@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
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😂
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
Ask questions in Eventhouse and KQL, Eventstream, and Reflex.
User | Count |
---|---|
86 | |
82 | |
64 | |
63 | |
56 |
User | Count |
---|---|
171 | |
113 | |
110 | |
73 | |
73 |