Forum Discussion

JeevanMallya's avatar
JeevanMallya
Icon for Resolver II rankResolver II
1 year ago
Solved

Need a Column that adds reported Cumulative defects

I have a Table with Reported Defects and I want to create a New column that shows Cummulative by Considering ISSUE_KEY Columns with actual defects reported and ignoring null.I have added index column...
Need Help
  • JeevanMallya's avatar
    JeevanMallya
    1 year ago

    Thank you

danextian's avatar
danextian
Icon for Super User rankSuper User
1 year ago

Try this:

Cumulative Count = 
VAR _Tbl =
    FILTER (
        'Project',
        Project[PROJECT_KEY] = EARLIER ( Project[PROJECT_KEY] )
            && Project[Index] <= EARLIER ( Project[Index] ) --only index with less than or equal to current row index
            && NOT ( ISBLANK ( Project[ISSUE_KEY] ) )
    )
RETURN
    SUMX ( _Tbl, [CREATED_COUNT] )

 

JeevanMallya's avatar
JeevanMallya
Icon for Resolver II rankResolver II
1 year ago

Thank you