Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Multiple Drills with a single axis

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

  • 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))

1 Reply

  • 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))