Forum Discussion

Niraj_vora0106's avatar
Niraj_vora0106
Helper III
4 years ago
Solved

Cumulative count

Hi, community, I'm trying to get the cumulative total calls in my data monthwise. As you can see if I'm using the Month number then the cumulative is working perfectly. But in Month's case, it is ...
Need Help
  • amitchandak's avatar
    amitchandak
    4 years ago

    Niraj_vora0106 , First of if you have date table, then you should use the month from dates table. Second distinct count  will not sum  , because same id can repeat across month

     

    Also you can use date, no need to use month, you can try like

     

     

    V3 Cumulative Total Calls =
    CALCULATE(DISTINCTCOUNT(T2363[IncidentNo]),
    FILTER(ALLSELECTED(DATES),
    DATES[Date] <= MAX(DATES[Date])))

     

    or


    V3 Cumulative Total Calls =
    CALCULATE(sumx(Values(Dates[Month]), calculate(DISTINCTCOUNT(T2363[IncidentNo]))),
    FILTER(ALLSELECTED(DATES),
    DATES[Date] <= MAX(DATES[Date])))

amitchandak's avatar
amitchandak
Super User
4 years ago

Niraj_vora0106 , First of if you have date table, then you should use the month from dates table. Second distinct count  will not sum  , because same id can repeat across month

 

Also you can use date, no need to use month, you can try like

 

 

V3 Cumulative Total Calls =
CALCULATE(DISTINCTCOUNT(T2363[IncidentNo]),
FILTER(ALLSELECTED(DATES),
DATES[Date] <= MAX(DATES[Date])))

 

or


V3 Cumulative Total Calls =
CALCULATE(sumx(Values(Dates[Month]), calculate(DISTINCTCOUNT(T2363[IncidentNo]))),
FILTER(ALLSELECTED(DATES),
DATES[Date] <= MAX(DATES[Date])))