Data Analysis Expressions (DAX)

Articles and deep-dives organized by module — pick a module to browse, or a title to start reading.

  1. Aggregation 23 Sep 2026 5 min read COUNT vs COUNTX in DAX: Understanding Counting Functions In this article, we will learn how to use COUNT and COUNTX in DAX to count values in a table. We will also understand…
  2. Aggregation 28 Sep 2026 6 min read Counting Boolean Values in DAX Using COUNTA and COUNTAX In this article, we will learn how to count values in a DAX table, with a special focus on Boolean values such as TRUE…
  3. Aggregation 28 Sep 2026 5 min read Counting Blank Values in DAX Using COUNTBLANK In this article, we will learn how to identify and count blank values in individual columns using the COUNTBLANK function in DAX. 📥 Practice…
  4. Aggregation 28 Sep 2026 4 min read Counting Rows in a Table Using COUNTROWS in DAX In this article, we will learn how to count the number of rows in a table using COUNTROWS in DAX. This is one of…
  5. Aggregation 28 Sep 2026 5 min read Counting Unique Values Using DISTINCTCOUNT and DISTINCTCOUNTNOBLANK in DAX In this article, we will learn how to count unique values in DAX using DISTINCTCOUNT and DISTINCTCOUNTNOBLANK. We will also understand the important difference…
  6. Aggregation 28 Sep 2026 6 min read Finding Minimum Values Using MIN and MINA in DAX In this article, we will learn how to find the minimum value from columns and compare values using MIN and MINA in DAX. We…
  7. Aggregation 28 Sep 2026 5 min read Finding the Minimum Value of an Expression Using MINX in DAX In this article, we will learn how to use MINX in DAX to evaluate an expression for every row of a table and return…
  8. Aggregation 28 Sep 2026 6 min read Finding Maximum Values Using MAX, MAXA and MAXX in DAX In this article, we will learn how to find maximum values in DAX using MAX, MAXA, and MAXX. We will also understand how MAXX…
  9. Aggregation 28 Sep 2026 5 min read SUM vs SUMX in DAX: Understanding Row-by-Row Calculations In this article, we will learn the difference between SUM and SUMX in DAX using a simple example. We will also see how COALESCE…
  10. Aggregation 28 Sep 2026 5 min read PRODUCT vs PRODUCTX in DAX: Handling Blank Values with COALESCE In this article, we will learn how to calculate the product of values using PRODUCT and PRODUCTX in DAX. We will also see how…
  11. Aggregation 28 Sep 2026 6 min read Understanding AVERAGE, AVERAGEX and AVERAGEA in DAX In this article, we will learn the difference between AVERAGE, AVERAGEX, and AVERAGEA in DAX. Although all three functions are related to calculating averages,…