Forum Discussion
Cumulative total for a count function doesn't work when I filter with containsstring
- 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
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