Working With Virtual In-Memory Tables In Power BI Using DAX

[@EnterpriseDNA]

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

[@Victor-ol1lo]

Virtual tables - seems to be very powerful and opens a ton of possibilities. Thanks Sam !

[@joaquimcosta952]

Amaizing staff.....I’m learning all the time. Thanks.

[@arnesbeganovic]

Simply the most powerfull part of PBI. Thanks for tutorial.

[@EnterpriseDNA]

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: kzbin.info/door/y2rBgj4M1tzK-urTZ28zcA

[@ph3ll3r]

Very elegant and powerful measure creation, thanks for your insights to problem solving.

[@liranzaidman1610]

There are not enough words to thank you. Amazing, this helped me so much

[@EnterpriseDNA]

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: kzbin.info/door/y2rBgj4M1tzK-urTZ28zcA

[@pukashell6170]

Thank you Sam Mckay. You've saved me again!

[@kennethstephani692]

Great video, Sam, as usual!!

[@EnterpriseDNA]

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!

[@hauseofraf]

Absolutely love your videos!

[@eladiobardelli3001]

Fascinante y elegante, gracias from end the World, Chile.

[@larl07]

YES. Not only is the topic fantastic, but we're moving to a white background dashboard too! Rock on! haha

[@danielsiffredi8403]

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

[@marceloabbiatiprado4460]

Fantastic, as always

[@qiancasper]

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

[@EnterpriseDNA]

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 KZbin 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 KZbin 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/ kzbin.info/door/y2rBgj4M1tzK-urTZ28zcA 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/ kzbin.info/www/bejne/l5-VZnurrs-iabM kzbin.info/www/bejne/b6WooHZsmqafgNE kzbin.info/www/bejne/noaZppyQidBpaqc

[@aryehhoffman4956]

Very informative. Thank you.

[@hi_vishy]

Simply adding up the ranks in already created measures would also have given the same result as the one with sumx...isn't it?

[@vd_1990]

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

[@EnterpriseDNA]

Hi Vishal, see here for some ideas on this - forum.enterprisedna.co/search?q=Virtual%20In-Memory

[@andrebarreira8242]

Is there a way to calculate de Median of this 3 factors? Thank you in advanced

[@EnterpriseDNA]

See here for some ideas on this - forum.enterprisedna.co/search?q=Calculate%20Median

[@janeilsonsousa9508]

very god. tks

[@ed2921]

Nice work Sam

[@ohmoneymoneyhome6430]

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 ?

[@EnterpriseDNA]

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 KZbin 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/ kzbin.info/door/y2rBgj4M1tzK-urTZ28zcA

[@Rebucados1]

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.

[@zaafirc369]

You can do another rankx on the rankings columns