Running Total

I’ll review some basic DAX running totals (aka cumulative totals) and then various advanced examples.

Change Total Row Calculation

If totals in your viz aren’t showing what you want DAX can change them.

I’m going to build a Funnel chart and recreate tooltip values using DAX measures.

Let’s use DAX to see if transaction data adheres to the 80-20 rule.

I want to segment aggregated data into groups. How can I automate the task of creating these segmentation groups?

I have 2 slicers based on the same column of U.S. states.

Question 1 is easy. Question 2 is tricky. It requires a virtual summary group by table. A what?

Some questions require a virtual table inside a measure to create the required data structure.