Forum Discussion
Ncf5031
Advocate I
Advocate ISubtract Row Value From Table Row Count - KM Survival Curve
Needing help with two seemingly simple issues. First, the goal of this analysis is to peform a KM Survival Analysis. I have searched here and the articles pertaining to that analysis don't quite...
Hi Ncf5031 ,
Please try this measure:
ALIVE_AT_TIME = VAR __EQUIP_HRS = MAX('FAILURES'[EQUIP_HRS]) VAR _Count_1 = CALCULATE(COUNTA('FAILURES'[EQUIP_HRS]),'FAILURES'[EQUIP_HRS]>=__EQUIP_HRS) VAR _Count_2 = COUNTBLANK('FAILURES'[EQUIP_HRS]) VAR _Count_3 = IF(ISBLANK(__EQUIP_HRS),_Count_1+_Count_2,_Count_1) VAR _Result = _Count_3 - [FAILURE_AT_TIME] RETURN _ResultBest Regards,
Gao
Community Support TeamIf there is any post helps, then please consider Accept it as the solution to help the other members find it more quickly. If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!
How to get your questions answered quickly -- How to provide sample data
Ncf5031Advocate I
Advocate IAnonymous my apologies for not updating. Your solution worked, I appreciate your assistance.