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

Question

Hello,I have the data below&nbsp;&nbsp;&nbsp;I want to have the cumulative data only for the item that contain cat1.I've used the formula below using containstring&nbsp;cat_1_only_cumulative=CALCULATE(&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; COUNT(Table1[Row Label]),&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; FILTER(ALLSELECTED(Table1[Attribute]),&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; Table1[Attribute]&lt;=MAX(Table1[Attribute])&nbsp;),&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;FILTER(Table1,CONTAINSSTRING(Table1[Row Label],"cat1")&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; ))It filters the row correctly but then the cumulative total are wrong I have this &nbsp;and I was expecting this&nbsp;&nbsp;Could you please help me to solve this problem to get the good cumulative amounts after filtering by items only containing cat1.&nbsp;Also is it possible to put the Measure cat_1_only_cumulative and then&nbsp; Measure cat_2_cumulative in a table as row with the dates like the example below&nbsp;Row Label01/01/202502/01/202503/01/202504/01/202505/01/202506/01/2025TOTALcat_1_only_cumulative1234566cat_2_cumulative&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;11&nbsp;&nbsp;Thanks for your help.&nbsp;&nbsp;

anonymous · Accepted Answer

Hi&nbsp;yanisyes&nbsp;,Please create measures like:
cat_1_only_cumulative = 
CALCULATE (
    COUNT ( Table1[Row Label] ),
    Table1[Attribute] &lt;= MAX ( Table1[Attribute] ),
    CONTAINSSTRING(Table1[Row Label],"cat1") 
)cat_2_only_cumulative = 
CALCULATE (
    COUNT ( Table1[Row Label] ),
    Table1[Attribute] &lt;= MAX ( Table1[Attribute] ),
    CONTAINSSTRING(Table1[Row Label],"cat2") 
)

Best Regards,GaoCommunity Support Team
&nbsp;
If there is any post&nbsp;helps, then please consider&nbsp;Accept it as the solution&nbsp;&nbsp;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.&nbsp;Thanks a lot!
How to get your questions answered quickly&nbsp;--&nbsp;&nbsp;How to provide sample data in the Power BI Forum&nbsp;--&nbsp;China Power BI User Group

Forum Discussion

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

2 Replies

Related content

Switch -Containsstring

ContainsString with OR function

Containsstring and Count

Cumulative Total

Measure with IF( CONTAINSSTRING

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