20260212-PowerBI-notes

Posted on Edited on In , ,

How it works

MAX(Events[Date]) = current date on the chart.

ALLSELECTED keeps slicer filters but ignores the current row context.

The filter counts all rows up to that date.

Use this measure on a line chart with:

Axis: Events[Date]

Values: Running Count

1
2
3
4
5
6
7
8
Running Count :=
CALCULATE(
    COUNTROWS(Events),
    FILTER(
        ALLSELECTED(Events[Date]),
        Events[Date] <= MAX(Events[Date])
    )
)