Forum Discussion

CR's avatar
CR
Resolver II
7 years ago
Solved

Cumulative count not working

Hi ! I'm lost because, usually, it works fine when I create a measure to cumulate the values by month. Today, no...   Here is a part of my Excel table:   Actual type TagName Validation Date...
Need Help
  • v-lili6-msft's avatar
    v-lili6-msft
    7 years ago

    hi, CR 

    Add a date table and then create the relationship with "MTI test" [Date]

    Then adjust your formula as below:

    Measure = 
    CALCULATE(COUNT('MTI test'[Actual type]),
                FILTER('MTI test','MTI test'[TagName Validation]="Not Validated"),
                FILTER('MTI test','MTI test'[Actual type]="Package"),
                FILTER(ALLSELECTED('Date'),'Date'[Date]<=MAX('Date'[Date])
	))

    Then right-click [Actual type] field and select "Show items with no data"

     

    My simple sample result:

    Best Regards,

    Lin

parry2k's avatar
parry2k
Super User
7 years ago

CR is this what you are looking for?

 

CR's avatar
CR
Resolver II
7 years ago

Hi parry2k 

 

I need to display this:

 

 
Actual type2018-092018-102018-122019-012019-02
Electrical     
HVAC     
INSTRUM     
LOOP     
Package35555
Total     

 

I just need to cumulate the CREATION DATE values without taking the END into account, and with cumulative data in the months coming after...

 

Regards,

CR

 

  • parry2k's avatar
    parry2k
    Super User
    7 years ago

    CR in that case create a date dimension table in your model and set relation  between createion date and date table, and update formula to use date from date dimension and that will do the job.