Find Lists Of Your Top Clients Across Difference Measures w/DAX in Power BI

Dynamically find lists of your clients using the RANKX function.

***** Video Details *****
1:45 - creating slicer
2:06 - ranking selection formula
3:37 - total sales by rank
7:30 - total profits by rank
8:00 - total profit margins by rank

***** Learning Power BI? *****

***** Related Links *****

***** Related Course Modules *****

***** Related Support Forum Posts *****

[EnterpriseDNA]

Learning Power BI?

Related Links

Related Course Modules

Related Support Forum Posts

[fabriciocarranza]

It was so helpful. I was finally able to get done what I needed. Thank you

[EastAG]

This is great! I do wish to show a subset in the bar chart though but keep it filtered as top 5 of the larger set.
Some context:
Top N Firms as a stacked bar chart with the legend being business segments.
I want it sorted by the top N firms by revenue and not ranking the firm per segment revenue. Solely the overall revenue

[samialhussieni]

very nice Sam. Your channel is very helpful and useful

[enriquemolina]

OK, this was really awesome. I worked perfectly for me and is exactly what I was looking for.
Thanks for the Video!

[christianlira]

Great presentations Sam and much appreciated.

[pythagorasdatascience]

Hi Sam, i would like to see an example where you filter TOPN but bring to the table other measures, not only the column with the result of the Rank, it is posible?

[xiaotongmu]

Could you explain the difference of using all(customer[customer name]) and values(customer[customer name]) inside the rankx function, thank you.

[ronvanderpoel]

Great video, only one question. When selecting Top 5 and Q1 2017, Top Profit Margins shows 7 bars instead of 5. Why is that?

[nandinipadam]

I am trying to find the top 10 tasks that cross SLA . Applied this but I am getting sum time in the output. Could you please help

[phyberoptx]

Have you ever been able to use both this dynamic ranking and dynamic measures (as per your 'Multi Threaded Dynamic Visuals" video) together? Nesting the dynamic measure inside the ranking measure seems not to work (all results are returned, no matter what the ranking slicer says).

[Carlzven]

Hello sam, thank you for your video. I have a problem to find number of stores/customers who does 20%, 30% or 80% of revenue. How to make Top N list when N = X %?

[hi_vishy]

I want to show top 5 customers plus a fixed customer. His can I achieve this?

[Gunterlund]

also is it possible to rank customers say between 25 and 100

[Gunterlund]

how do I go to the next line in the measure statement. I entered Top Sales by Rank but when I hit enter to go to the next line nothing happens

[LuisLopez-scqc]

pero que tambien exista para clientes con ventas mas bajas los ultimos 3, 5 dentro de los top en una sola se puede lo he intentado pero no me sale