***** Learning Power BI? ***** FREE COURSE - Ultimate Beginners Guide To Power BI - portal.enterprisedna.co/p/ultimate-beginners-guide-to-power-bi FREE COURSE - Ultimate Beginners Guide To DAX - portal.enterprisedna.co/p/ultimate-beginners-guide-to-dax FREE - 60 Page DAX Reference Guide Download - enterprisedna.co/dax-formula-reference-guide-download FREE - Power BI Resources - enterprisedna.co/power-bi-resources Enterprise DNA Membership - enterprisedna.co/membership Enterprise DNA Online - portal.enterprisedna.co/ Enterprise DNA Events - enterprisedna.co/enterprise-dna-events-page/ ***** Related Links ***** How To Understand Virtual Tables Inside Iterating Functions In Power BI - DAX Concepts - blog.enterprisedna.co/how-to-understand-virtual-tables-inside-iterating-function-in-power-bi-dax-concepts/ Deep Dive Into RANKX - DAX Formula Concepts In Power BI - blog.enterprisedna.co/deep-dive-into-rankx-dax-formula-concepts-in-power-bi/ Group Customers Dynamically By Their Ranking w/RANKX In Power BI - blog.enterprisedna.co/group-customers-dynamically-by-their-ranking-wdax-in-power-bi/ ***** Related Course Modules ***** Mastering DAX Calculations - portal.enterprisedna.co/p/mastering-dax-calculations Advanced DAX Combinations - portal.enterprisedna.co/p/advanced-dax-combinations Learning Summit Series - portal.enterprisedna.co/p/learning-summit-series ***** Related Support Forum Posts ***** DAX Virtual Table Logic To Modify Context - forum.enterprisedna.co/t/dax-virtual-table-logic-to-modify-context/2580 How Can I Retrieve A Value From A Virtual Table? - forum.enterprisedna.co/t/how-can-i-retrieve-a-value-from-a-virtual-table-and-place-in-each-row-of-report/1567 Virtual Tables And Problem With Time Intelligence DAX Functions - forum.enterprisedna.co/t/virtual-tables-and-problem-with-time-intelligence-dax-functions/5151 For more virtual table support queries to review see here…. - forum.enterprisedna.co/search?q=virtual%20table
Hi Kenneth, glad that this video is of help! If you haven't yet, you can subscribe to our channel to see all our upcoming Power BI and Power Platform video tutorials and announcements. Cheers!
Hi Arnes Beganovic, glad you appreciated the video. You can subscribe to our channel to see all our upcoming Power BI video tutorials. Here’s the link: th-cam.com/channels/y2rBgj4M1tzK-urTZ28zcA.html
Hi לירן זיידמן , great that you found value in this video. You can subscribe to our channel to see all our upcoming Power BI video tutorials. Here’s the link: th-cam.com/channels/y2rBgj4M1tzK-urTZ28zcA.html
Excellent Sam. Quick question: does this technique improve performance vs running three measures separately and then calculating the total? I’m very interested on performance improvement techniques because I’m dealing with very large tables. Thanks again. Daniel
Hi Sam, Thanks for this. Just wondering that the minimum value for the ordering factor would now be 3, correct (as it’s just a sum of three ranking categories). If that’s the case, should we not rank this factor so that it starts from 1 for aesthetic reasons? Thanks
Hey Sam thanks for sharing could you pls share more samples with virtual tables? In Power Query we able to use virtual table which we able to see with our own eyes just wonder whether it has the same way in Dax, look forward to hearing from you~~ Really appreciated in advance
Hello Casper, Thank you for posting your query onto our channel. We really appreciate you taking your valuable time to post it. Well, firstly as you said: "In Power Query we able to use virtual table which we able to see with our own eyes" - it's incorrect. The tables which you can actually see in the Power Query are called as "Physical Tables" and not virtual tables. Virtual tables are the tables which are created virtually i.e. has no physical presence or not visible in the data model. 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 TH-cam channel pertaining to this topic i.e. Virtual Tables. Also one of our expert has created a video which shows the distinction between the type of tables in Power BI. 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. Also, make sure that you're subscribed to our TH-cam 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/ th-cam.com/channels/y2rBgj4M1tzK-urTZ28zcA.html www.linkedin.com/groups/12004506/ blog.enterprisedna.co/tables-in-power-bi-types-distinctions/ community.powerbi.com/t5/Community-Blog/Examples-Of-Virtual-Tables-amp-Their-Importance-To-Advanced/ba-p/516973 blog.enterprisedna.co/how-to-understand-virtual-tables-inside-iterating-function-in-power-bi-dax-concepts/ blog.enterprisedna.co/discover-the-intersect-function-in-dax-and-how-to-utilize-it-power-bi-tutorial/ th-cam.com/video/an25Huyjo3Q/w-d-xo.html th-cam.com/video/9tEoC6eAlJo/w-d-xo.html th-cam.com/video/hU6uiZTk64E/w-d-xo.html
hello, I have a question. when I follow your method working on my own sales & profit data, I got some blank value in overall ranking. but i checked in each VAR rank, they all have a value. do you have any idea what error it might be ?
Hello oh moneymoneyhome, Thank You for posting your query onto our channel. Well it's always a little bit difficult to judge and provide the results pertaining without looking at the data structure, model and working of the PBIX file for the reference. 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 and helpful. Also make sure that you're subscribed to our TH-cam channel so that you don't miss out on any updates pertaining to the Power BI. Happy Learning! Thanks and Warm Regards, Enterprise DNA forum.enterprisedna.co/ th-cam.com/channels/y2rBgj4M1tzK-urTZ28zcA.html
Is there anyway we can normalize the overall ranking to start from 1, followed by 2 and so on? I've tried to divide the sum of rankings by a factor but since data is always changing I'm afraid that strategy wouldn't work in a long term. I would need an algorithm that would re-calculate the sum of rankings and normalize them automatically.
***** Learning Power BI? *****
FREE COURSE - Ultimate Beginners Guide To Power BI - portal.enterprisedna.co/p/ultimate-beginners-guide-to-power-bi
FREE COURSE - Ultimate Beginners Guide To DAX - portal.enterprisedna.co/p/ultimate-beginners-guide-to-dax
FREE - 60 Page DAX Reference Guide Download - enterprisedna.co/dax-formula-reference-guide-download
FREE - Power BI Resources - enterprisedna.co/power-bi-resources
Enterprise DNA Membership - enterprisedna.co/membership
Enterprise DNA Online - portal.enterprisedna.co/
Enterprise DNA Events - enterprisedna.co/enterprise-dna-events-page/
***** Related Links *****
How To Understand Virtual Tables Inside Iterating Functions In Power BI - DAX Concepts - blog.enterprisedna.co/how-to-understand-virtual-tables-inside-iterating-function-in-power-bi-dax-concepts/
Deep Dive Into RANKX - DAX Formula Concepts In Power BI - blog.enterprisedna.co/deep-dive-into-rankx-dax-formula-concepts-in-power-bi/
Group Customers Dynamically By Their Ranking w/RANKX In Power BI - blog.enterprisedna.co/group-customers-dynamically-by-their-ranking-wdax-in-power-bi/
***** Related Course Modules *****
Mastering DAX Calculations - portal.enterprisedna.co/p/mastering-dax-calculations
Advanced DAX Combinations - portal.enterprisedna.co/p/advanced-dax-combinations
Learning Summit Series - portal.enterprisedna.co/p/learning-summit-series
***** Related Support Forum Posts *****
DAX Virtual Table Logic To Modify Context - forum.enterprisedna.co/t/dax-virtual-table-logic-to-modify-context/2580
How Can I Retrieve A Value From A Virtual Table? - forum.enterprisedna.co/t/how-can-i-retrieve-a-value-from-a-virtual-table-and-place-in-each-row-of-report/1567
Virtual Tables And Problem With Time Intelligence DAX Functions - forum.enterprisedna.co/t/virtual-tables-and-problem-with-time-intelligence-dax-functions/5151
For more virtual table support queries to review see here…. - forum.enterprisedna.co/search?q=virtual%20table
Virtual tables - seems to be very powerful and opens a ton of possibilities. Thanks Sam !
Great video, Sam, as usual!!
Hi Kenneth, glad that this video is of help! If you haven't yet, you can subscribe to our channel to see all our upcoming Power BI and Power Platform video tutorials and announcements. Cheers!
Amaizing staff.....I’m learning all the time. Thanks.
Simply the most powerfull part of PBI. Thanks for tutorial.
Hi Arnes Beganovic, glad you appreciated the video. You can subscribe to our channel to see all our upcoming Power BI video tutorials. Here’s the link: th-cam.com/channels/y2rBgj4M1tzK-urTZ28zcA.html
Very elegant and powerful measure creation, thanks for your insights to problem solving.
There are not enough words to thank you.
Amazing, this helped me so much
Hi לירן זיידמן , great that you found value in this video. You can subscribe to our channel to see all our upcoming Power BI video tutorials. Here’s the link: th-cam.com/channels/y2rBgj4M1tzK-urTZ28zcA.html
Thank you Sam Mckay. You've saved me again!
Excellent Sam. Quick question: does this technique improve performance vs running three measures separately and then calculating the total? I’m very interested on performance improvement techniques because I’m dealing with very large tables.
Thanks again. Daniel
YES. Not only is the topic fantastic, but we're moving to a white background dashboard too! Rock on! haha
Absolutely love your videos!
Fascinante y elegante, gracias from end the World, Chile.
Hi Sam,
Thanks for this.
Just wondering that the minimum value for the ordering factor would now be 3, correct (as it’s just a sum of three ranking categories). If that’s the case, should we not rank this factor so that it starts from 1 for aesthetic reasons?
Thanks
Hi Vishal, see here for some ideas on this - forum.enterprisedna.co/search?q=Virtual%20In-Memory
Simply adding up the ranks in already created measures would also have given the same result as the one with sumx...isn't it?
Is there a way to calculate de Median of this 3 factors? Thank you in advanced
See here for some ideas on this - forum.enterprisedna.co/search?q=Calculate%20Median
Hey Sam thanks for sharing could you pls share more samples with virtual tables? In Power Query we able to use virtual table which we able to see with our own eyes just wonder whether it has the same way in Dax, look forward to hearing from you~~ Really appreciated in advance
Hello Casper,
Thank you for posting your query onto our channel. We really appreciate you taking your valuable time to post it.
Well, firstly as you said: "In Power Query we able to use virtual table which we able to see with our own eyes" - it's incorrect. The tables which you can actually see in the Power Query are called as "Physical Tables" and not virtual tables.
Virtual tables are the tables which are created virtually i.e. has no physical presence or not visible in the data model.
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 TH-cam channel pertaining to this topic i.e. Virtual Tables. Also one of our expert has created a video which shows the distinction between the type of tables in Power BI.
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. Also, make sure that you're subscribed to our TH-cam 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/
th-cam.com/channels/y2rBgj4M1tzK-urTZ28zcA.html
www.linkedin.com/groups/12004506/
blog.enterprisedna.co/tables-in-power-bi-types-distinctions/
community.powerbi.com/t5/Community-Blog/Examples-Of-Virtual-Tables-amp-Their-Importance-To-Advanced/ba-p/516973
blog.enterprisedna.co/how-to-understand-virtual-tables-inside-iterating-function-in-power-bi-dax-concepts/
blog.enterprisedna.co/discover-the-intersect-function-in-dax-and-how-to-utilize-it-power-bi-tutorial/
th-cam.com/video/an25Huyjo3Q/w-d-xo.html
th-cam.com/video/9tEoC6eAlJo/w-d-xo.html
th-cam.com/video/hU6uiZTk64E/w-d-xo.html
Fantastic, as always
hello, I have a question. when I follow your method working on my own sales & profit data, I got some blank value in overall ranking. but i checked in each VAR rank, they all have a value. do you have any idea what error it might be ?
Hello oh moneymoneyhome,
Thank You for posting your query onto our channel.
Well it's always a little bit difficult to judge and provide the results pertaining without looking at the data structure, model and working of the PBIX file for the reference.
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 and helpful. Also make sure that you're subscribed to our TH-cam channel so that you don't miss out on any updates pertaining to the Power BI.
Happy Learning!
Thanks and Warm Regards,
Enterprise DNA
forum.enterprisedna.co/
th-cam.com/channels/y2rBgj4M1tzK-urTZ28zcA.html
Is there anyway we can normalize the overall ranking to start from 1, followed by 2 and so on? I've tried to divide the sum of rankings by a factor but since data is always changing I'm afraid that strategy wouldn't work in a long term. I would need an algorithm that would re-calculate the sum of rankings and normalize them automatically.
You can do another rankx on the rankings columns
Very informative. Thank you.
Nice work Sam
very god. tks