DAX help

[Anonymous]

Hi had a dataset see the top part in below, and i want to achieve the calculation/measure in below.  please help. thanks. 

[Seward12533]

Its not hard but you need to understand how PowerBI works and some simple dax but some complex concepts. First and foremost you need a date table or other table of unique sequential values) to take advantage of DAX Time Intelligence so you can do Cumulative functions Can't really take the time to explain so here is an example.

https://1drv.ms/u/s!AuCIkLeqFmlhhJh3pj3q9XzrxpxAng

[prateekraina · Accepted solution]

Hi @Anonymous,

Here are the measures:

Total Active = 
CALCULATE (
    COUNT ( 'Table'[Customer] ),
    FILTER (
        ALL ( 'Table'),
        'Table'[Sign Up Date] <= MAX ( 'Table'[Sign Up Date] )
        && 'Table'[Status] = "Active"
    )
)


Cancelled Today =
IF (
    MAX ( 'Table'[Status] ) = "Cancelled",
    1,
    0
)


Cancelled % in Today =
DIVIDE (
    [Cancelled Today],
    [Total Active],
    0
)

Here is the screenshot:

Kindly accept my answer as solution if i have solved your problem. Also, don't forget to hit the thumbs up.

Prateek Raina