Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago

Modify a Cumulative Measure

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] )
   
))
Need Help
Show and Tell

2 Replies

  • DataVitalizer's avatar
    DataVitalizer
    Super User
    3 years ago

    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

  • Dhairya's avatar
    Dhairya
    Solution Supplier
    3 years ago

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