Forum Discussion
yanisyes
2 years agoFrequent Visitor
Cumulative total for a count function doesn't work when I filter with containsstring
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...
- Anonymous2 years ago
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 TeamIf 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
Ashish_Mathur
2 years agoSuper User
Hi,
Why are you trying to pass the Cat1 condition in the CALCULATE() function? Why not give that condition in the FILTER() pane?