Cumulative total for a count function doesn't work when I filter with containsstring

[yanisyes]

Hello,
I have the data below 

I want to have the cumulative data only for the item that contain cat1.
I've used the formula below using containstring 

cat_1_only_cumulative=CALCULATE(

                COUNT(Table1[Row Label]),

                FILTER(ALLSELECTED(Table1[Attribute]),

                        Table1[Attribute]<=MAX(Table1[Attribute]) ),

                         FILTER(Table1,CONTAINSSTRING(Table1[Row Label],"cat1")

                        ))

It filters the row correctly but then the cumulative total are wrong I have this

and I was expecting this 

Could you please help me to solve this problem to get the good cumulative amounts after filtering by items only containing cat1.

Also is it possible to put the Measure cat_1_only_cumulative and then  Measure cat_2_cumulative in a table as row with the dates like the example below 

Row Label	01/01/2025	02/01/2025	03/01/2025	04/01/2025	05/01/2025	06/01/2025	TOTAL
cat_1_only_cumulative	1	2	3	4	5	6	6
cat_2_cumulative						1	1

Thanks for your help.

[Ashish_Mathur]

Hi,

Why are you trying to pass the Cat1 condition in the CALCULATE() function?  Why not give that condition in the FILTER() pane?

[Anonymous · Accepted solution]

Hi @yanisyes ,

Please create measures like:

cat_1_only_cumulative = 
CALCULATE (
    COUNT ( Table1[Row Label] ),
    Table1[Attribute] <= MAX ( Table1[Attribute] ),
    CONTAINSSTRING(Table1[Row Label],"cat1") 
)

cat_2_only_cumulative = 
CALCULATE (
    COUNT ( Table1[Row Label] ),
    Table1[Attribute] <= MAX ( Table1[Attribute] ),
    CONTAINSSTRING(Table1[Row Label],"cat2") 
)

Best Regards,
Gao
Community Support Team

If there is any post helps, then please consider Accept it as the solution  to help the other members find it more quickly.
If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!

How to get your questions answered quickly --  How to provide sample data in the Power BI Forum -- China Power BI User Group