Multiple Drills with a single axis

[Anonymous]

Please 
I'd love to know if it is possible to make this visualization such that there are two drills, first the names ending wiht UFF and secondly those ending wiht SCC, without neccessarily creating another column

[amitchandak · Accepted solution]

@Anonymous , I doubt you can do that without creating a column.

Maybe you a measure like this drill report

calculate(Sum(Table[Value]), filter(All(Table[column1]), Search(right(Table[column1],3),Table[column1],,0) >0))