Category: DAX Studio

Power BI Data Model Optimization With VertiPaq

Power BI Data Model Optimization With VertiPaq - Enterprise DNA

In this tutorial, you’ll learn how to use the VertiPaq Analyzer in DAX Studio to optimize your data model in Power BI. VertiPaq Analyzer is a built-in tool in DAX Studio that extracts meaningful information about tabular models from an optimization standpoint. To launch VertiPaq Analyzer, go to the Advanced tab in DAX Studio. Then,

Continue reading

CROSSJOIN DAX Function: Server Timings & Query Plan

CROSSJOIN DAX Function Server Timings & Query Plan - Enterprise DNA

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

Continue reading

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

Template In Power BI: Using A Prebuilt To Load DMV Results

Template In Power BI Using A Prebuilt To Load DMV Results - Enterprise DNA

In this tutorial, you’ll learn how to load the results of a dynamic management view (DMV) using a prebuilt template in Power BI. This template is created by Brett Powell from Insight Quest. You can download the file from the GitHub repository. Once the download is finished, open the file. You need to input the

Continue reading

RANKX Deep Dive: A Power BI DAX Function

RANKX Deep Dive A Power BI DAX Function - Enterprise DNA

Today, we will dive deep into RANKX, a scalar DAX function in Power BI that allows you to return the ranking of a specific number in each table row that forms part of a list of numbers. You can watch the full video of this tutorial at the bottom of this blog. Sample Scenarios We’ll

Continue reading