In this tutorial, you’ll learn how the CROSSJOIN function works in DAX using the Server Timings pane and its query plan. The CROSSJOIN function can be used to create a Cartesian product of two tables. A Cartesian product is a set of all possible combinations of rows from two or more tables. The DAX code
Tag: Query Plans
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
This tutorial will discuss about setting up DAX Studio and measuring query performance in Power BI. These information will help detect bottlenecks in the query so that you can eliminate them and optimize your DAX. Setting Up DAX Studio Open the DAX Studio tool and connect your model. In this example, the EDNA Optimizing DAX
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