158 cards
This deck walks you through the DAX patterns you'll reach for again and again in Power BI. It starts with the foundational questions, like the difference between a calculated column and a measure, and then builds into the formulas that drive real reports, including totals, distinct counts, year-over-year changes, year-to-date totals, and percent-of-total calculations. You'll also practice the workhorse functions of DAX, such as CALCULATE, ALL, ALLSELECTED, and the iterator family (SUMX, AVERAGEX, and similar), so you start to recognize which one to pull up for a given problem.
It's a great fit if you already know your way around the Power BI desktop, can build a basic visual, and now want to move beyond dragging fields onto a canvas into writing your own measures. If you're newer to DAX but comfortable with Excel formulas, these cards can still work for you, as long as you're willing to experiment in a practice file alongside the deck.
DAX really clicks when you see patterns repeat, so try to connect each card to a real report you've built or imagined. When you study, mix up the order rather than going front to back in one sitting; your brain benefits from retrieving the formula in slightly different contexts, which is exactly the kind of active recall this deck is designed to support.
A practical tip as you work through the cards: keep DAX Studio or a simple test visual open so you can verify each pattern with a small example, because seeing the result of a measure on real numbers is the fastest way to build intuition for things like filter context and the difference between ALL and ALLSELECTED.