Forum Discussion

NessFlood's avatar
NessFlood
Helper I
8 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#]))
 

 

3 Replies

  • Arul's avatar
    Arul
    Super User
    8 months ago

    NessFlood ,

    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])
        )
    )
)
    • NessFlood's avatar
      NessFlood
      Helper I
      8 months ago

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