Forum Discussion
How can I group rows based on certain special characters
For example here is a chart Category Value razor 10 disposable razor 11 shave 0 razor for men 2 ...
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/
Do you by chance know how to do it with two searches? For example, "razor" and "shampoo" to make the razorshampoo measure as 49?
tackytechtom
Most Valuable Professional
Most Valuable ProfessionalHi 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/