Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
8 years ago
Solved

DAX help

Hi had a dataset see the top part in below, and i want to achieve the calculation/measure in below.  please help. thanks.   
Need Help
  • prateekraina's avatar
    prateekraina
    8 years ago

    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

prateekraina's avatar
prateekraina
Memorable Member
8 years ago

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