When To Use TOPN In Power BI - DAX Formula Review

TOPN is a great DAX function to use in Power BI when you have some internal ranking logic that you want apply to your calculation.

There are many occasions where there is a better formula combination to use than the alternative of RANKX.

There is a lot reviewed around this topic in the tutorial so, enjoy!

Sam

***** Video Details *****
1:17 - total number of cities with purchases
3:08 - calculating the top two cities
5:50 - calculating the bottom two cities

***** 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

[tayedawa]

Just what I was looking for! I am gonna shine tomorrow! Thank you.

[mnowako]

Excellent! Just to the point! Thanks Sam!

[sambolade]

Hi Sam. Thanks for the video, I wanted to ask what the Delivery Region is made of as I have not been able to replicate the formula

[antipghosh]

Sir, How to do summation of first 3 numbers in a series in power bi....?
Series: {5, 7, 2, 3, 9, 10, 2}
Desired sum: 5+7+2

[milosnova]

Thanks Sam! I have one additional question. Do you have a Dax suggestion when I get an Error: Dax can't work because The table of multiple values was supplied where a single value was expected. If I use Desktops Built in TopN Bottom 1 I get the right answer.


Thank's.

[williamarthur]

Hi, Has anyone noticed a difference in result when using a measure for order by expression as opposed to a column so
EVALUATE
TOPN( 3,
SUMMARIZECOLUMNS( Table1[Item], Table1[Units]), Table1[Units], DESC)
EVALUATE
TOPN(3,
SUMMARIZECOLUMNS( Table1[Item], Table1[Units]), [TopUnits], DESC) // TopUnits = SUMTable1[Units)

Bring back different result, if anyone can recommend vid or blog that deals with this please let me know.