RANKX Considerations - Power BI & DAX Formula Concepts 

That's great, nice one.

Hi Tomas, glad this video is of help. You can subscribe to our channel to see all our upcoming Power BI video tutorials. Cheers!

Hi Los Angeles, It's a bit difficult to assess and give recommendation without looking at the data structure, model and working of the PBIX file for the reference. You can reach out to us on our Community Forum by providing a detailed description of your query along with relevant files for reference. Our members and team of Experts will be happy to help out! If you haven't yet, do subscribe to our RU-vid channel and LinkedIn group to keep posted on the latest data skills and tools updates. Cheers, Enterprise DNA forum.enterprisedna.co/ www.youtube.com/@EnterpriseDNA www.linkedin.com/groups/12004506/

Yes that's a lot of rows to iterate through for RANKX. I think some optimization would have to occur with that formula. Maybe look at reducing the 'virtual table' part of the formula.

Instead of all use allselected

For help like this check out the Enterprise DNA Support Forum - forum.enterprisedna.co/search?q=RANKX

Hello Rehan Shaikh, Thank you for posting your query onto our channel. Below are the measures/formulas provided for the reference wherein you can remove the "Rank" from the total row from your table. Product Rank = VAR _Product_Ranking = RANKX( ALL( Products ) , [Total Sales] , , DESC ) RETURN IF( ISBLANK( SELECTEDVALUE( Products[Product Name] ) ) , BLANK() , _Product_Ranking ) Customer Rank = VAR _Customer_Ranking = RANKX( ALL( Customers ) , [Total Sales] , , DESC ) RETURN IF( ISBLANK( SELECTEDVALUE( Customers[Customer Name] ) ) , BLANK() , _Customer_Ranking ) Also if you don't want to write a complex measure then in that case you can format it and hide the "Rank" from the total row. Below are the steps provided for the reference - Select the table. Click onto the "Format" menu. Go to the "Field Formatting" section. From the drop-down menu, select the "Product Rank" option. Select the font color as "White". Enable the "Apply to total" option and disable the "Apply to values" option. And you'll see that "Rank" from the total row will get "Hidden" i.e. it's still calculated but not shown whereas in the case of measure/formula it's simply calculated for all the individual rows but not for the total row. So we've provided you with both the options. You can go for either of them whichever suits your requirements. 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. Also, make sure that you're subscribed to our RU-vid channel so that you don't miss out on any updates pertaining to the Power BI. Along with it 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/ ru-vid.com/show-UCy2rBgj4M1tzK-urTZ28zcA www.linkedin.com/groups/12004506/

Hi Lakshmi, see here for some ideas on this - forum.enterprisedna.co/search?q=RANKX

Hi Erika, It's not possible to suggest anything without looking at your data Model, Measure etc. If you are a member of Enterprise DNA, please raise a new topic at forum forum.enterprisedna.co/ or explore forum for similar issues. Regards, Enterprise DNA

Hi Gulherme, Thank You for posting your query onto our channel. Could you please post your query onto our community forum where our members as well as our Experts will be able to assist you in a better manner? We're providing a link below of our forum. Thanks and Warm Regards, Enterprise DNA forum.enterprisedna.co/

Hello Neha Chakraborty, thank you for posting your query onto our channel. Well it's always a little bit difficult to judge and provide the results without looking at the data structure, model and working of the PBIX file for the reference since we don't know what context you're supplying and how the results are getting evaluated. And therefore we encourage you to please write back to us onto our Community Forum by providing the proper description of the problem that you're facing along with the PBIX file for the reference as well as the mock-up results that you're trying to achieve 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. Hoping you find this useful. Happy Learning!!! forum.enterprisedna.co/

Hello Diogo Xerez, Thank you for posting your query onto our channel. We're providing few of the links of the articles from our blog posts as well as links of the videos from our Enterprise DNA RU-vid channel pertaining to this topic. 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. Also, make sure that you're subscribed to our RU-vid channel so that you don't miss out on any updates pertaining to the Power BI. Cheers, Enterprise DNA forum.enterprisedna.co/ ru-vid.com/show-UCy2rBgj4M1tzK-urTZ28zcA blog.enterprisedna.co/rankx-in-power-bi-developing-custom-tiebreakers/ ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-HkR1JVzmvRw.html ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-1givosMLhCI.html

Just rewatched twice you video and figured it out! great explanation!!! thanks

Hello kartik kanodia, thank you for posting your query onto our channel. Well, you can try out the below formula pattern to show the highest value ever in your KPI card using "MAXX" function. Below is the formula pattern provided for the reference - Highest Sales of All Time = CALCULATE( MAXX( Sales , [Total Sales] ) , ALL( Dates[Date] ) ) We're presuming that you want to show the sales figure. Alternatively, using same formula pattern you can determine highest value of any category. Still if you've any questions, you can post it on our Power BI Community Forum where our members and expert team will be able to assist you in a better and efficient manner. We're providing a link below of our Community Forum as well. Hoping you find this useful and meets your requirements that you've been looking for.🙂 Happy Learning!!! forum.enterprisedna.co/

Hello akash ragi, Thank You for posting your query. We're providing a link from our Community Forum where one of our experts have addressed this issue. This will help you in your scenario. Moreover, you can also download the PBIX file provided as a solution in that thread. The link is provided below: forum.enterprisedna.co/t/pareto-topn-tree-map-issue/8690/9 For more queries, you can also reach out to us through our Community Forum. 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.🙂 Also make sure that you're subscribed to our RU-vid channel so that you don't miss out on any updates pertaining to the Power BI. Along with it, 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. Happy Learning!!! Thanks and Warm Regards, Enterprise DNA forum.enterprisedna.co/ ru-vid.com/show-UCy2rBgj4M1tzK-urTZ28zcA www.linkedin.com/groups/12004506/ forum.enterprisedna.co/t/pareto-topn-tree-map-issue/8690/9

If you download this resources here you'll find a few combinations of how this can be calculated - enterprisedna.co/power-bi-resources

@@EnterpriseDNA Great video, as always. Thank you! But why it doesn't work if instead of [Total Sales] I put SUM( 'Sales Data'[Total Revenue] ) ?