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?
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/