Cumulative count

Power BI
1

Hi,

I need little guidance on the below scenario. please can you help

I have registrations for events. need to show cumulative count of registrations for selected year.
the cumulative count should start in descending order of weeks to go column. attached is a sample data.

Sample.xlsx (11.1 KB)

2

@swapnil,

See if the attached PBIX is what you’re looking for.

Hope this is helpful.

image
image858×425 15.9 KB

Key measure is:

Cumulative Registrations = 
    CALCULATE (
        [Total Registrations],
        FILTER (
            ALLSELECTED ( Registration_Fact ),
            MIN ( Registration_Fact[weeks_to_go] ) <= Registration_Fact[weeks_to_go]
        )
    )

Sam has a bunch of great videos on cumulative totals. Here are a few:

https://forum.enterprisedna.co/t/cumulative-totals-deep-dive-power-bi-dax-formula-review/2959

https://forum.enterprisedna.co/t/cumulative-totals-allselected/3318

https://forum.enterprisedna.co/t/cumulative-totals-measure-branching/3319

eDNA Forum - Cumulative Count.pbix (36.7 KB)

3

Thank you.
I already did that but when I put event edition as a legend, the lines are overlapping.
So I thought I am doing wrong in the formula.

4

Thanks Brian,
Found the mistake with my report and I got this fixed. Appreciate your help.

Best Regards
Swapnil