Forum Discussion

ajisharavind_99's avatar
ajisharavind_99
Advocate I
3 years ago
Solved

Cumulative Progress

Hi,   I am looking for a solution to the calculate cumulative progress based on the last date i.e., I have already calculated the cumulative progress, but when I apply the date filter, it is calcul...
Cumulative Calculation
Help Request
  • FreemanZ's avatar
    FreemanZ
    3 years ago
    tyr to replace ALLSELECTED with ALL:
     
    CALCULATE (
        [Plan_Progress],
        FILTER (
            ALL ( Month_Table ),
            Month_Table[Date]
                <= MAX ( Month_Table[Date] )
        )
    )
FreemanZ's avatar
FreemanZ
Super User
3 years ago
tyr to replace ALLSELECTED with ALL:
 
CALCULATE (
    [Plan_Progress],
    FILTER (
        ALL ( Month_Table ),
        Month_Table[Date]
            <= MAX ( Month_Table[Date] )
    )
)