Tag: Logical Query Plan

DAX CALCULATETABLE Vs FILTER Function

DAX CALCULATETABLE Vs FILTER Function - Enterprise DNA

Both CALCULATETABLE and FILTER are powerful tools for manipulating and analyzing data in DAX query, but they have some key differences that are important to understand. In this blog, we’ll go over the CALCULATETABLE function and its query plan in DAX studio, and understand how it differs from the FILTER function. By the end, you’ll

Continue reading

Query Plan & Server Timings In DAX Studio

Query Plan & Server Timings In DAX Studio - Enterprise DNA

In this tutorial, you’ll learn about Query Plan and Server Timings in DAX Studio. This is an overview of what happens behind the scenes whenever you run a DAX query. You can find the Query Plan and Server Timings option in the Traces pane under the Home tab. Query Plan In DAX Studio When you

Continue reading

Storage Engine In Power BI – VertiPaq Operators & Queries

Storage Engine In Power BI – VertiPaq Operators & Queries

This tutorial will discuss about the VertiPaq operators and storage engine queries in Power BI. You’ll learn how operators work behind the calculation and how the storage engine helps you to optimize your DAX codes’ performance. The VertiPaq operators and queries allow you to monitor the execution of each code so that you can improve

Continue reading

DAX Query In Power BI – Logical & Physical Query Plans

DAX Query In Power BI – Logical & Physical Query Plans

This tutorial will discuss about the two DAX Query Plans in Power BI. Query plans affect the DAX’s performance in generating valuable data. They also help in optimizing DAX codes that make your report more compelling. These are the two query plans that are generated by the formula engine: Every DAX query triggers these two

Continue reading