In this chapter, you'll write custom functions to create calculated measures. You'll also get introduced to variables to make writing DAX functions more efficient.

Methods to create DAX measures

50 XP

Advantages of explicit measures

100 XP

DAX and Measures

50 XP

Using variables

100 XP

Basic statistical measures

100 XP

Quick measures

100 XP

챕터 시작

Filtering and Counting with DAX

Expand your DAX power with some commonly used DAX measures. This chapter focuses on filtering and counting functions.

Filtering and counting with DAX

50 XP

Understanding different filter functions

100 XP

Using different filters with DAX

50 XP

Filter ALL the data

100 XP

Calculating with a filter

100 XP

챕터 시작

Iterating Functions

This chapter covers the core concept of another powerful set of DAX functions, the so called iterating functions. You will explore iterations with exercises focusing on ranking and iterating your data.

Iterating functions

50 XP

DIY iterating functions

100 XP

Iterating functions in Power BI

50 XP

Practice with iterating functions

100 XP

More iterating functions

100 XP

Use of RANKX()

100 XP