December 16, 2022
DAX
September 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. A
December 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 of breaking
November 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 ALL in
November 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 the kind
November 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 carry out
October 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 Row Context
October 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 it into
October 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 BI reports.
October 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 used in
7, Ropo Owolabi Street, Morgan Estate Phase 2, Ojodu, Lagos.