Forum Discussion

NessFlood's avatar
NessFlood
Icon for Helper I rankHelper I
9 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 ðŸ˜ƒ   MEASU...
  • NessFlood's avatar
    NessFlood
    9 months ago

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

Arul's avatar
Arul
Icon for Super User rankSuper User
9 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
    Icon for Helper I rankHelper I
    9 months ago

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