How and why to Create VIRTUAL TABLES in DAX Formulas

[@akshaynikam6628]

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

[@NestorAdrianzen]

Akshay, thanks for your feedback. Keep it up👍

[@ALPHERATZ3650]

Excelente explicacion

[@NestorAdrianzen]

Gracias por revisar el contenido José. Saludos 👍

[@IvanCortinas_ES]

Very useful Nestor. Thank you for the video.

[@NestorAdrianzen]

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

[@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

[@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

[@xeeshanahmad8757]

Fabulous 👍

[@NestorAdrianzen]

Glad to hear that. Cheers!

[@就已]

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!

[@abdulqadeerkamangar6279]

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

[@kirillmelnikov1700]

Thank you) U have helped me

[@NestorAdrianzen]

Thanks for stopping by!

[@alsega7]

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

[@NestorAdrianzen]

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

[@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!

[@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

[@erinfield1943]

Creating new table- 8:06

[@NestorAdrianzen]

Excellent! Thanks for stopping by.

[@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.