How do I fix this specific measure for my table (cumulative by month)?

[BBHouston]

I have the following table visual (you can ignore the "Newly Registered" column): 



I want the "Running Count MONTH" total to be cumulative. So instead of 192-54-4, I want it to show up as 192-246-250. Here is my current measure that is still giving me the above result:

Running Count MONTH = CALCULATE(COUNTROWS('Table1'), FILTER(ALL('Table1'[Date]), MONTH('Table1'[Date]) <= MONTH(MAX('Table1'[Date])) && NOT(ISBLANK('Table1'[Date]))))

What mistake is in my measure and how do I fix it to get the result I want? 

[V-pazhen-msft · Accepted solution]

@BBHouston 

The problem is the filter expression, try  use max([date].[month.no]):

Running Count MONTH = CALCULATE(COUNTROWS('Table1'), FILTER(ALLSELECTED('Table1'[Date]), [Date].[Month.no] <= Max([Date].[Month.no]) && NOT(ISBLANK('Table1'[Date]))))

Paul Zheng _ Community Support Team
If this post helps, please Accept it as the solution to help the other members find it more quickly.

[Ashish_Mathur]

Hi,

Share the link from where i can download your PBI file.

[BBHouston]

@Ashish_MathurThank you for the reply. Unfortunately, it's giving me the exact same result. I'm guessing i would need to add the MONTH function somewhere there as well? 

[jdbuchanan71]

@BBHouston Give this a try.

Running Count =
VAR _MaxDate = MAX ( 'Table1'[Date] )
RETURN
    CALCULATE (
        COUNTROWS ( 'Table1' ),
        FILTER (
            ALL ( 'Table1'[Date] ),
            'Table1'[Date] <= _MaxDate
                && NOT ( ISBLANK ( 'Table1'[Date] ) )
        )
    )