How and why to Create VIRTUAL TABLES in DAX Formulas

How and why to Create Virtual Tables in DAX//
In this lesson, I am going to show you how and why to create virtual tables in DAX formulas.
Navigate through the content below:
0:42 Agenda
1:10 What are virtual tables?
2:36 Uses of virtual tables?
4:25 Displaying the results of virtual tables
6:66 Practical Case
Content Link: drive.google.com/file/d/1qyJA...
___________
Highly recommended Power BI books (Affiliate links):
***Exper Data Modeling with Power BI by Soheil Bakhshi
Hard Cover Book: amzn.to/3DyVwrc
E-Book: amzn.to/3mMQ0uf
***The Definitive Guide to DAX: Business Intelligence for Microsoft Power BI, SQL Server Analysis Services, and Excel Second Edition: amzn.to/3ldPLpk
***DAX Patterns (Second Edition): amzn.to/3fBKdnD
***Analyzing Data with Power BI and Power Pivot for Excel: amzn.to/3fDPLOd
***Beginning DAX with Power BI: amzn.to/3fDEe1k
***Storytelling with Data: A Data Visualization Guide for Business Professionals: amzn.to/3mfPcwE
***Storytelling with Data: Let's Practice!: amzn.to/36c6Cot
***Information Dashboard Design: amzn.to/2V61o7h
___________Relevant PBI Topics
- MEASURES vs CALCULATED COLUMNS in DAX: • MEASURES vs CALCULATED...
- How to Use the ALL DAX Function in Power BI: • How to Use the ALL DAX...
- How to Use the Filter DAX Function in Power BI [The Basics]: • How to Use the Filter ...
- How to Calculate PERCENTAGES in Power BI: • How to Calculate PERCE...
- How to COMBINE Tables in Power BI: • How to COMBINE Tables ...
____________
[DISCLAIMER]: Some links included in this description might be affiliate links. If you purchase a product with those links, I might receive a small commission. However, there is no additional charge to you! I appreciate your support and this will help me provide you with free content on a weekly basis.
If you like the content, feel free to buy me a cup of coffee 😀👇paypal.me/vizxlizationUS
If you don't want to miss anything, subscribe to our newsletter: vizxlization.com/welcome-to-v...
___________Let's Connect:
Web: www.vizxlization.com/
LinkedIn: / vizxlization
Twitter: / vizxlization
Facebook: / vizxlization
Instagram: / nestoradrianzen
Leave your comments and questions below!
Don't forget to subscribe!
Thanks so much!
#VirtualTables #DAX #PowerBI #vizxlization

[@akshaynikam6628]

Thank you for your wonderful video..! It's completely good Content

[@NestorAdrianzen]

Akshay, thanks for your feedback. Keep it up👍

[@IvanCortinas_ES]

Very useful Nestor. Thank you for the video.

[@NestorAdrianzen]

Glad it was helpful! Keep it up, Iván.

[@xeeshanahmad8757]

Fabulous 👍

[@NestorAdrianzen]

Glad to hear that. Cheers!

[@user-ze4xc6tu4f]

Great video and great topic

[@NestorAdrianzen]

Glad you found it helpful. Cheers!

[@sachithnavarathne9362]

Hi Nestor! Great content. I do have a question. I want to create a virtual, but it needs to have a column with a calculation as well, on top of selecting columns from other tables. Any recommendations? Thanks!

[@ALPHERATZ3650]

Excelente explicacion

[@NestorAdrianzen]

Gracias por revisar el contenido José. Saludos 👍

[@kirillmelnikov1700]

Thank you) U have helped me

[@NestorAdrianzen]

Thanks for stopping by!

[@pedrodias4355]

Hi Nestor, in the calculate table example, instead of summarizing the country on the visual, how could we summarize it by country on the calculate table virtual table? Thanks for the content, really helpful. Regards Pedro

[@abdulqadeerkamangar6279]

Great content How can we create table having multiple top5 based on counts from two columns product and country to create scattered diagram?

[@rogervandecraen9797]

Great tutorial and very helpful, I want to create a virtual table an use it to lookup a value from the table. but hwo to use the columns from a virtual table as they are not visable. ?

[@NestorAdrianzen]

Roger, Thanks for stopping by. You are correct, we cannot see virtual tables unless we use DAX table functions to intentionally create a physical table in the model (Modeling > New table). What are you trying to accomplish? You might want to use Power Query to create a physical table to lookup a specific value. This process is called NORMALIZATION in data modeling. This tutorial will provide some guidance. I hope this helps. Cheers! kzbin.info/www/bejne/gHWmmWumZ8eNgpI

[@bss43]

Hi how to drill through with multiple selected values in Power BI . Is it still impossible? or at least not force to select "a single data point from.." to be able to use simple PageNavigation action with Slicers applied. (by default it "forgets" slicer selections)... any solution for this?

[@bss43]

what I would like to achieve, is using mix (selecting items) in slicers and be able to click on items on visuals and then click "DrillThrough" , but not only on one specific item but on multiple - and these selections should be applied on Detailed page. Currently after selecting multiple items on charts(visual) after clicking on DrillThrough button I see "please select a single data point" and it does not redirect to Detailed page...

[@NestorAdrianzen]

BS S, Thanks for stopping by. As far as I know and as of today, Drill through is only available for single data points. There might be some logic behind that the engine doesn't allow to have multiple selections. You might want to check the Power BI community suggestions about this topic: community.powerbi.com/t5/Desktop/Drill-through-with-multiple-selected-values-doesn-t-seem-to-pass/m-p/1211027#M539995

[@aiinabox1260]

Nice video, does calendar() is also creating virtual table .?

[@NestorAdrianzen]

Raj, That's a good question. In theory, all DAX functions that result in a table of values can create a virtual table. However, virtual tables are usually embedded in other functions. Remember, virtual tables are not physically stored in the model. So going back to your question, if the CALENDAR results are not embedded in other table functions, it's not a virtual table. I hope this helps!

[@alsega7]

👍🏻👍🏻. Tienes este contenido en español?. Gracias.

[@NestorAdrianzen]

Alonso, gracias por revisar el contenido. Lo tengo en mi lista. Saludos

[@SergiyVakshul]

Why do you call it "Virtual Table"? In documentation it is mentioned as "table or table expression".

[@NestorAdrianzen]

Sergiy, Thanks for stopping by. Yes, a table expression can be a Virtual Table if it's part of a measure or calculated table.