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.
Hello
I have a matrix where the columns are stores, the rows are collections and the values are sales.
I am looking for a dynamic stores ranking. That is, if I write in the filter a top ‘2’, it should show the two best selling stores and then see how their sales are distributed by collection. But it doesn't work!
In this image, if we write top 2, it should show only shops 5 and 4, because they are the first two in sales and the matrix shows more.
I hope you can help me. I share you my pbix file
https://drive.google.com/file/d/137SC6UYQ7MyLM0uIhbv95CTMrrsCfARn/view?usp=sharing
Thank you! :))
Thank you!
All measures work in a table but not in the matrix, do you know how can add these?
I tried as visual level filter and measure in visual, but it doesn't work
@x-datita , First have measure that only use store level total
Store Measure = calculate([Meausre] , filter(all(Table), Table[Store] =max(Table[Store]) )
or
Store Measure = calculate([Meausre] , removefilters(Table[Collection]) )
Now have a rank on this and use that as visual level filter
Rank = Rankx(allselected(Table[Store]), [Store Measure])
or use top N, and use this measure in visual
calculate([Measure],keepfilters(TOPN(selectedvalue(TOPN[Value]) , allselected(Table[Store]), [Store Measure], desc)))
You can also consider Window or new Rank function
Power BI - New DAX Function: RANK - How It Differs from RANKX: https://youtu.be/TjGkF44VtDo
Dynamic TOPN using TOPN/Window and Numeric parameter: https://youtu.be/vm2mdEioQPQ
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 |
---|---|
89 | |
80 | |
65 | |
63 | |
60 |
User | Count |
---|---|
166 | |
114 | |
100 | |
73 | |
66 |