Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
10 months ago
Solved

MISSING CALCULATION IN CUMULATIVE DAX

I am using the formula below to calculate cumulative data but when there are weeks with both "Complete" and "Overdude" figures, the forumula doesn't work - your help is much appreciated ðŸ˜ƒ

 

MEASURE CUMULATIVE SDD REVIEW =
IF(
    MAX('CBR_REPORT'[DDS280 Pre-Build SDD Review Complete With NGCC FC Status])="Complete",
    COUNTX(
    FILTER(ALLSELECTED('CBR_REPORT'),
    'CBR_REPORT'[DDS280 Pre-Build SDD Review Complete With NGCC FC Status]="Complete" &&
    'CBR_REPORT'[DDS280 Pre-Build SDD Review Complete With NGCC FC]<=MAX('CBR_REPORT'[DDS280 Pre-Build SDD Review Complete With NGCC FC])),[Ref ID#]))
 

 

  • Anonymous's avatar
    Anonymous
    10 months ago

    worrked a treat, thank you so much ðŸ˜ƒ

3 Replies

  • Arul's avatar
    Arul
    Icon for Super User rankSuper User
    10 months ago

    Anonymous ,

    try this formula

     

    CALCULATE(
    COUNTROWS(
        FILTER(
            ALLSELECTED('CBR_REPORT'),
            'CBR_REPORT'[DDS280 Pre-Build SDD Review Complete With NGCC FC Status] = "Complete"
                && 'CBR_REPORT'[DDS280 Pre-Build SDD Review Complete With NGCC FC] <= MAX('CBR_REPORT'[DDS280 Pre-Build SDD Review Complete With NGCC FC])
        )
    )
)
    • Anonymous's avatar
      Anonymous
      Not applicable
      10 months ago

      worrked a treat, thank you so much ðŸ˜ƒ

  • Arul's avatar
    Arul
    Icon for Super User rankSuper User
    10 months ago

    Anonymous ,

    If that works, please mark my solution as a accepted solution.