Modify a Cumulative Measure

[Anonymous]

Hey Gurus,

I have this Cumulative measure below that counts number of cumulative hires this month, however, it shows zero when there are no hires in a certain month. ex below: Jan is 0 when it should be 22.

Cumalitive_HC_Mthly = CALCULATE (

    distinctCOUNT ( WD_HC[Employee ID] )+0,

    FILTER (

        ALLEXCEPT(WD_HC,WD_HC[Org],WD_HC[Worker],WD_HC[Tower],WD_HC[Territory]),

        WD_HC[Rank_Month] <= MAX (WD_HC[Rank_Month] )

))

[Dhairya]

Hey @Anonymous 
Can you please provide sample data that I can copy and try on my machine?

[DataVitalizer]

Hi @Anonymous 
I tried to duplicate your example with a different data sample and it worked, here is the measure I created

Measure = 
SUM(MyTable[Value])+
CALCULATE (
    SUM ( MyTable[Value] ),
    FILTER (
        ALL( MyTable),
        MyTable[Date]
            < MAX ( MyTable[Date])
    )
)

Did it work ?  ‌‌ Mark it as a solution to help spreading knowledge
Was this exchange helpful? A kudos 👍 would be appreciated