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

v-lili6-msft's avatar
v-lili6-msft
Community Support
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