Measure with running total per date and per category

[IvanS]

Hi guys,

I would desperately need your help with creating running total per both date and per category.

I have created following function that is showing data correctly with slicers. However after adding column "Tariff name" (which is in the same table) into legend of Bar chart, data are incorrect. Please refer to the attached screenshots:

Cumulative drivers (registered at) = 

CALCULATE (
    COUNT( dbo_DIM_Driver[DriverID]),
        NOT(ISBLANK(dbo_DIM_Driver[Registered At])),
            FILTER (ALLSELECTED(dbo_DIM_Driver),
                dbo_DIM_Driver[Registered At] <= MAX (dbo_DIM_Driver[Registered At]))
)

Applying slicer on running total - woking OK:

Applying legend into Stacked column chart - NOT OK - as you can see, the tariff "Journalist" is showing completely wrong numbers.

Any help is much appreciated!

Thank you

IvanS

[amitchandak · Accepted solution]

@IvanS , Join your date with date table, use period from date table in visual and measure like

Cumulative drivers (registered at) =

CALCULATE (
COUNT( dbo_DIM_Driver[DriverID]),
NOT(ISBLANK(dbo_DIM_Driver[Registered At])),
FILTER (ALLSELECTED(date),
date[date] <= MAX (date[date]))
)

Why Time Intelligence Fails - Powerbi 5 Savior Steps for TI :https://youtu.be/OBf0rjpp5Hw
https://amitchandak.medium.com/power-bi-5-key-points-to-make-time-intelligence-successful-bd52912a5b...
To get the best of the time intelligence function. Make sure you have a date calendar and it has been marked as the date in model view. Also, join it with the date column of your fact/s. Refer :radacad sqlbi My Video Series Appreciate your Kudos.