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

2 Replies

  • 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

  • Seward12533's avatar
    Seward12533
    Solution Sage
    8 years ago

    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