Forum Discussion

samdep's avatar
samdep
Icon for Advocate II rankAdvocate II
5 years ago
Solved

Running Total

Hi Everyone -    I've created a calculated column that looks at the count of days from a client request to intake of that client - off of two date fields.   I then created a measure for a running...
  • HashamNiaz's avatar
    HashamNiaz
    5 years ago

    Hi !

    You cna try using ISBLANK() function to get desired output;

     

    Cume Intakes = 
IF ( ISBLANK('Assessment'[Intake Count])
    , BLANK()
    , CALCULATE(COUNT('Assessment'[Connection to Intake Diff in Days]),
        FILTER(ALLSELECTED('Assessment'[Connection to Intake Diff in Days]),
        'Assessment'[Connection to Intake Diff in Days] <= MAX('Assessment'[Connection to Intake Diff in Days])))
)

     

    Regards,

    Hasham

HashamNiaz's avatar
HashamNiaz
Icon for Solution Sage rankSolution Sage
5 years ago

Hi !

You cna try using ISBLANK() function to get desired output;

 

Cume Intakes = 
IF ( ISBLANK('Assessment'[Intake Count])
    , BLANK()
    , CALCULATE(COUNT('Assessment'[Connection to Intake Diff in Days]),
        FILTER(ALLSELECTED('Assessment'[Connection to Intake Diff in Days]),
        'Assessment'[Connection to Intake Diff in Days] <= MAX('Assessment'[Connection to Intake Diff in Days])))
)

 

Regards,

Hasham

samdep's avatar
samdep
Icon for Advocate II rankAdvocate II
5 years ago

HashamNiaz that worked perfectly, thank you!