Working With Totals

Sooner or later you’ll want to change how a visual total works. Here’s a good example.

Dynamic X axis on charts

Slicer value dynamically changes the x axis on a chart.

Median Product Sales

Some only write measures on data they can see in tables. This is often a bad habit.

SUMMARIZE saves the day

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

Measure Uses Virtual Table

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