How can I group rows based on certain special characters

Hi Anonymous ,

How about this:

And here the measure:

RazorMeasure = 
CALCULATE (
    SUM ( Table[Value] ),
    SEARCH ( "Razor", Table[Category], 1, BLANK() )
)

Does this solve your issue?

/Tom
https://www.tackytech.blog/
https://www.instagram.com/tackytechtom/

Hi Anonymous ,

How about this:

RazorMeasure2 = 
CALCULATE (
    SUM ( Table[Value] ),
    SEARCH ( "Razor", Table[Category], 1, BLANK() ) || SEARCH ( "Shampoo", Table[Category], 1, BLANK() )
)

Please consider marking this reply as a solution, if it solves your issue. 🙂

/Tom
https://www.tackytech.blog/
https://www.instagram.com/tackytechtom/