Forum Discussion

yanisyes's avatar
yanisyes
Frequent Visitor
2 years ago
Solved

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...
  • Anonymous's avatar
    Anonymous
    2 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 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