#### Is AVERAGE the right DAX function for Average?

Introduction The most used functions in DAX have to be SUM(), COUNT() (and it’s colleagues) and AVERAGE(). There is no big deal with the first two. AVERAGE() however, has to be properly thoughtRead More

Dec 16, 2022####
Is AVERAGE the right DAX function for Average?

Introduction The most used functions in DAX have to be SUM(), COUNT() (and it’s colleagues) and AVERAGE(). There is no big deal with the first two. AVERAGE() however, has to be properly thoughtRead More

Sep 20, 2021####
DAX Formula To Rank Based On Multiple Values

Performing ranking in DAX is simple enough when you are considering just single numerical values. I mean, for example, it’s easy to rank Products based on Total Sales. But consider the scenario below.Read More

Dec 5, 2020####
Gentle Introduction To Variables In DAX

Beasty DAX DAX formulas can quickly become very complicated and difficult to read especially when you start to combine many functions in one single formula. Variables in a DAX is a way ofRead More

Nov 29, 2020####
When to Combine ALL and FILTER – Functions in Focus (Part 2) –

In my previous post, I wrote about ALL and FILTER functions in DAX. And I mentioned that ALL is usually used as an argument in FILTER. When do you combine FILTER and ALLRead More

Nov 19, 2020####
Functions In Focus: ALL and FILTER (Part 1)

In my previous post, I introduced 3 Table Functions You Must Master. FILTER, ALL and VALUES. The reason you must master them is simple: they provide the most common ways for defining theRead More

Nov 7, 2020####
3 DAX Table Functions You Must Master

Writing DAX in Power BI is always against tables isn’t it? Our data are stored in tables, so analyzing them with DAX requires us to send DAX functions against the tables to carryRead More

Oct 29, 2020####
Thinking like DAX – Understanding Filters Context

Introduction Struggling to write measures is usually down to one’s understanding of Filters context. This is because DAX is computed based on an Evaluation context which consists primarily of 2 contexts: The RowRead More

Oct 19, 2020####
Syntax Sugar – SUM Is SUMX In Disguise

Quick Introduction Do you know syntax sugar? May be not, but you know Sugar. It’s sweet. Writing DAX Measures usually require the use of Functions. The group of functions that always make itRead More

Oct 12, 2020####
Practical Introduction to DAX (Intro to Row Level Security)

Using DAX to implement Data Confidentiality How does Power BI ensure confidentiality? Row Level Security (RLS) is one of the key features that allow report creators access level control on their Power BIRead More

Oct 4, 2020####
Practical Introduction to DAX (Intro to Measures)

Overview In this series, I have introduced Calculated Tables, Calculated Columns, and It’s time to introduce Measures. Before moving on to introduce Row Level Security next week. Data Analysis Expressions (DAX), also usedRead More