cumulative count on monthly new members by type of members

[shaun96]

I have a list of dates with the type of member that signed up. 

total count = 
CALCULATE(
COUNT('Sheet1'[Account Type]),
    FILTER(
        ALLSELECTED('Sheet1'),
        'Sheet1'[Date] <= MAX('Sheet1'[Date])
    )
)

I want to do a cumulative count on a bar graph.

but my dax isn;t working. 

Date	Account Type
1/01/2023	Basic
1/01/2023	Basic
1/01/2023	Basic
1/01/2023	Standard
1/02/2023	Basic
1/02/2023	Basic
1/02/2023	Standard
1/02/2023	Standard
1/02/2023	Standard

[v-zhangti]

Hi, @shaun96 

Has your problem been solved, if so, please consider Accept a correct reply as the solution or share your own solution to help others find it. If not, please provide more information and your desired output.

Best Regards

[Jihwan_Kim · Accepted solution]

Hi,

I am not sure how your semantic model looks like, but please check the below picture and the attached pbix file if it suits yours requirement.

Total count cumulate: =
CALCULATE (
    COUNTROWS ( Data ),
    FILTER (
        ALLSELECTED ( Data ),
        Data[Account Type] = MAX ( Data[Account Type] )
            && Data[Date] <= MAX ( Data[Date] )
    )
)