Hi all, please forgive me, but there is a significant error in the formulas in this video which Leonardo has pointed out below in a comment. (possibly could be to do with the late night recordings! who knows) Anyways....If you are looking to rank by say 'Total Sales' then the third parameter needs to be 'Total Sales' not the column name. TOPN will rank based on the 'order by expression' you give it. So you could order by anything. Through the error in this video I have ultimately rank by alphabetical order which obviously is a pretty useless insight if you think about it. This is a perfect example where you can get results and then think, ok I must have it correct when actually it is totally wrong and calculating something that to very different from what you were looking to achieve. Anyway please note this. I will use this technique a lot in the future as it's a great way to discover insights fast. Until next time. Chrs, Sam
Thank you for this mate. what I was thinking of is flagging out the actual top products. what would the calculate function look like? calculate(customers, topn(.............ect?
Keep up the good work, videos are super easy to understand - getting a lot out of following this channel - simply one of the best channels if you want to get better with power bi. Thank you Sam.
Hello, Topn is useful when it shows only the top 2 products or top 10 customers from the whole list, but in your formula all the products are highlighted in the table without any segregation. So, what's the benefit? If i am doing some mistake in understanding your working, please clarify. Thanks
Hello Sam, Is it possible to add another row with the total sales for the rest of the customer? In your case, right after Virginia called "sales other customers"
Hi there, In the top customers through time video you have used DESC to get the top 10 customers but here you are using ASC. I am bit confused can you suggest which is correct , what exactly I need to use while calculating the TOP N values. Whether it should be ASC or DESC kindly clarify my doubt.
Thank you for this!! Is there a way I can export my topN table with slicer? Whenever I export to excel, it exports the whole rows (sample: 50 rows instead of the top 10) Thank you so much!!
Hello Laurice Villarino, thank you for posting your query onto our channel. Once you select the slicer and have the results for the "TOP 10" then select the table visual that you want to export and on the top-right side of the visual click onto the 3 dots (...) and select the option of export data. And now, you'll have the filtered data in the Excel file. For furthermore queries, you can also reach out to us onto our Community Forum where our members as well as experts team will be able to assist you in a better and efficient manner. Below is the link of the forum provided for the reference as well. Hoping you find this useful and meets your requirements that you've been looking for. Happy Learning!!! forum.enterprisedna.co/
Thanks for the Video. Is there a way to update the TOP N numbers dynamically from the report? Like TOPN(Variable) and This Variable should change based upon the Slicer drop down values.
As written, is the ranking the top two products taken over all states, or the unique top 2 products within each state? And how would one do the way that this isn't (i.e. contrast)? :) Thanks, very informative video.
There is a small issue with the formula, as mentioned in the other comment (I'll be updating soon), but regarding your question, it depends in which context the calc. is in. Because it's being filtered by each state at each row in the table it is by state, but if it wasn't then it would be across all states.
Hello Troy, Thank you for posting your query onto our channel. We really appreciate you taking your valuable time to post it. Well, actually we're not able to understand your query here i.e. the context that you're trying to highlight and the explanation of the concept that you want from us. We sincerely request you to please write back to in an elaborate manner by highlighting the query that you've and the explanation that you would like from us so that we can explain you in a better and efficient manner and it'll help you to strengthen your understanding of the fundamentals or concepts. Hoping you find this useful. Also, make sure that you're subscribed to our RUclips channel so that you don't miss out on any updates pertaining to the Power BI. You can also join our Power BI group on LinkedIn to receive latest updates on Power BI. Below are the links provided for the reference purposes. Cheers, Enterprise DNA forum.enterprisedna.co/ ruclips.net/channel/UCy2rBgj4M1tzK-urTZ28zcA www.linkedin.com/groups/12004506/
Excuseme, to download the RUclips models, I pay $47 for downloading all the models that are shown on RUclips? Or it's just the one you're seeing. Regards
Hi mohd muzammil, thanks for posting your comment here in the video. This topic has been discussed several times in Enterprise DNA Forum. You might get the answers you are looking for. If you want to check it out here is the link: forum.enterprisedna.co/search?q=Rankx%20%26%20Topn
Hi all, please forgive me, but there is a significant error in the formulas in this video which Leonardo has pointed out below in a comment. (possibly could be to do with the late night recordings! who knows) Anyways....If you are looking to rank by say 'Total Sales' then the third parameter needs to be 'Total Sales' not the column name. TOPN will rank based on the 'order by expression' you give it. So you could order by anything. Through the error in this video I have ultimately rank by alphabetical order which obviously is a pretty useless insight if you think about it.
This is a perfect example where you can get results and then think, ok I must have it correct when actually it is totally wrong and calculating something that to very different from what you were looking to achieve.
Anyway please note this. I will use this technique a lot in the future as it's a great way to discover insights fast.
Until next time. Chrs, Sam
The error has confused me and I believe it should be DESC not ASC. Is there an updated video on this topic?
You are seriously the best instructor I have come across in RUclips. Thanks for all these great videos.
Thank you for this mate. what I was thinking of is flagging out the actual top products.
what would the calculate function look like?
calculate(customers,
topn(.............ect?
Keep up the good work, videos are super easy to understand - getting a lot out of following this channel - simply one of the best channels if you want to get better with power bi. Thank you Sam.
No problem. Chrs
Hello, Topn is useful when it shows only the top 2 products or top 10 customers from the whole list, but in your formula all the products are highlighted in the table without any segregation. So, what's the benefit? If i am doing some mistake in understanding your working, please clarify. Thanks
Hello Sam, Is it possible to add another row with the total sales for the rest of the customer? In your case, right after Virginia called "sales other customers"
Hi there,
In the top customers through time video you have used DESC to get the top 10 customers but here you are using ASC. I am bit confused can you suggest which is correct , what exactly I need to use while calculating the TOP N values. Whether it should be ASC or DESC kindly clarify my doubt.
For top N it should be desc
Thank you for this!!
Is there a way I can export my topN table with slicer? Whenever I export to excel, it exports the whole rows (sample: 50 rows instead of the top 10)
Thank you so much!!
Hello Laurice Villarino,
thank you for posting your query onto our channel.
Once you select the slicer and have the results for the "TOP 10" then select the table visual that you want to export and on the top-right side of the visual click onto the 3 dots (...) and select the option of export data. And now, you'll have the filtered data in the Excel file.
For furthermore queries, you can also reach out to us onto our Community Forum where our members as well as experts team will be able to assist you in a better and efficient manner. Below is the link of the forum provided for the reference as well.
Hoping you find this useful and meets your requirements that you've been looking for.
Happy Learning!!!
forum.enterprisedna.co/
Nice
claire explanation ! 👍
Thanks for the Video. Is there a way to update the TOP N numbers dynamically from the report? Like TOPN(Variable) and This Variable should change based upon the Slicer drop down values.
Here's how you can do this - ruclips.net/video/S7eMccO1_bE/видео.html
As written, is the ranking the top two products taken over all states, or the unique top 2 products within each state? And how would one do the way that this isn't (i.e. contrast)? :) Thanks, very informative video.
There is a small issue with the formula, as mentioned in the other comment (I'll be updating soon), but regarding your question, it depends in which context the calc. is in. Because it's being filtered by each state at each row in the table it is by state, but if it wasn't then it would be across all states.
Newer to Power BI, but why did the TopN function designating a "10" result in 10 rows being returned?
Hello Troy,
Thank you for posting your query onto our channel. We really appreciate you taking your valuable time to post it.
Well, actually we're not able to understand your query here i.e. the context that you're trying to highlight and the explanation of the concept that you want from us.
We sincerely request you to please write back to in an elaborate manner by highlighting the query that you've and the explanation that you would like from us so that we can explain you in a better and efficient manner and it'll help you to strengthen your understanding of the fundamentals or concepts.
Hoping you find this useful. Also, make sure that you're subscribed to our RUclips channel so that you don't miss out on any updates pertaining to the Power BI. You can also join our Power BI group on LinkedIn to receive latest updates on Power BI. Below are the links provided for the reference purposes.
Cheers,
Enterprise DNA
forum.enterprisedna.co/
ruclips.net/channel/UCy2rBgj4M1tzK-urTZ28zcA
www.linkedin.com/groups/12004506/
hi...suppose i have 50 rows and i have used Rank for top 20 record and rest i want as " all others"
how to achieve that ???
For help like this check out the Enterprise DNA Support Forum - forum.enterprisedna.co/
Excuseme, to download the RUclips models, I pay $47 for downloading all the models that are shown on RUclips? Or it's just the one you're seeing. Regards
All the training resources on RUclips (currently there is about 50). At portal.enterprisedna.co. You can see every resource which is included. Chrs
When to use Rankx & Topn
Hi mohd muzammil, thanks for posting your comment here in the video. This topic has been discussed several times in Enterprise DNA Forum. You might get the answers you are looking for.
If you want to check it out here is the link: forum.enterprisedna.co/search?q=Rankx%20%26%20Topn
You must deleted this video because had errors