Category: DAX

How To Get Your Dataset’s Top N In Power BI

How To Get Your Dataset's Top N In Power BI - Enterprise DNA

In today’s blog, we will walk you through the process of using Quick Measures Pro to create a custom measure that returns the top N items in Power BI based on a specific metric. It’s a useful technique for data visualization and analysis, allowing you to quickly identify the top performers in your dataset. You can

Continue reading

Power BI Custom Sort Using DAX

Power BI Custom Sort Using DAX - Enterprise DNA

Many people believe that we cannot perform Power BI custom sort using DAX, but that is not true. DAX can absolutely guarantee sort, and it’s actually pretty simple to do. In today’s blog, I will show you how you can easily do exactly that. You can watch the full video of this tutorial at the bottom

Continue reading

The CALCULATE DAX Function: Issues & Solutions

The CALCULATE DAX Function Issues & Solutions - Enterprise DNA

In today’s blog, we will explore why you should not use the CALCULATE DAX function to obtain Average Per Category and provide some alternative solutions to get the same results you want. You can watch the full video of this tutorial at the bottom of this blog. Getting an Average Per Category in DAX is

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

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