Top 5 Tips & Tricks For Debugging Virtual Tables In Power BI

Virtual tables are my personal favorite DAX topic because I think they're the key to unlocking the full power of DAX. Virtual tables are the only type of tables within Power BI that are fully dynamic, and there are problems that can only be solved by applying virtual table techniques within your measures. For this tutorial, I’m going to share my Top 5 tips and tricks that I’ve accumulated over the years for visualizing, breaking down, and fixing problems with virtual tables in Power BI.

Brian

Links mentioned in the video:

***** Video Details *****
00:00 Introduction
01:17 The problem
04:15 Tip #1
05:54 Tip #2
10:25 Tip #3
13:34 Tip #4
17:05 Tip #5
18:20 Format DAX measures in a model

***** Learning Power BI? *****

#EnterpriseDNA #PowerBI #PowerBIDesktop #PowerBITutorial #DAX #DAXTutorial #PowerBIVirtualTable #VirtualTable

[emilmubarakshin]

Thanks Brian. Debugging is always great tool to have and "seeing is believing".
This is excellent - the last "virtual table" might be exactly what I was looking for to deal with data that spans for multiple row for some records....

[tomduffhues]

Hi Brian, Thank you for this video! It is exactly what I now need where I need to extract the nth value. Excellent explanation, good 'cheat' with the concatenatex/unichar (10).

[hermesjrd]

Thanks a Lot, Great Video, Great Tips

[qiancasper]

Thanks for sharing And it helps me to have the way to check the content of virtual table awesome

[mehdihammadi]

Very informative, thank you for sharing

[frederikforum]

Hi Brian & EDNA,

I know i am a bit late to the video. However, i have a problem where i want to test what the virtual table shows based on what is selected on my page. This is due to using an ALLSELECTED() statement that should affect my measure dynamically based on what teams are selected.

So my question is: Can you do something similar in DAX Studio as what you did with the Nth Item slider value measure? Fx i have 10 teams and the measure is calculating a benchmark dynamically based on the teams selected. I want to test what values the table return when i select only team 1 & 2?

Is this possible?

Kind Regards

Frederik

Ps. Your videos are extemely usefull and a big help!