Cumulative Total in a stacked column chart - issue with column series

[avardaneg]

Hi All,

I'm a newbie so forgive me in case my question is dumb, but I've been banging my head looking at other posts and cannot figure out a solution for my issue. I've created a measure to calculate cumulative counts for my column chart. The count works fine for the totals until I add a column to the columns series to stratify the count:

This is my measure:

CumCount =

CALCULATE (

COUNT( CN_Data[CNStartDate] ),

FILTER (

ALLNOBLANKROW( CN_Data ),

CN_Data[Superseded] = "N" && CN_Data[CNState] = "Implementation" && CN_Data[DesignerCN] = "Y" && CN_Data[CNStartDate] <= MAX(CN_Data[CNStartDate]

)

)

)

What am I missing here?

[v-jingzhang · Accepted solution]

Hi @avardaneg 

The problem is at ALLNOBLANKROW. You could use ALLEXCEPT instead and put the column which is added to the columns series in it. This can keep the filter on the column series field. ALLEXCEPT function (DAX)

CumCount =
CALCULATE (
    COUNT ( CN_Data[CNStartDate] ),
    FILTER (
        ALLEXCEPT ( CN_Data, CN_Data[Column series field] ),
        CN_Data[Superseded] = "N"
            && CN_Data[CNState] = "Implementation"
            && CN_Data[DesignerCN] = "Y"
            && CN_Data[CNStartDate] <= MAX ( CN_Data[CNStartDate] )
    )
)

Below is an example with SUM. The logic is similar. 

Best Regards,
Community Support Team _ Jing
If this post helps, please Accept it as Solution to help other members find it.

[avardaneg]

Hi Jing,

Thanks a lot for your help!!! 👍