Create a group

[kari1282]

Hi I was wondeirng if there is a  measure that would allow me to make a group. For example I have a column called Titles and it consist of of 

Title

Associate 1

Associate 2

Associate 3

Associate 4

Senior Associate 

Senior Associate 2

Senior Associate 3

Senior Associate 4

I want to make the following group -Associate (Associate 1, Associate 2, Associate 3 & Associate 4). I'm using live data and am not able to create a group or any new columns. was wondeirng if there was a measure that would allow me to create the group. 

Thanks

[amitchandak · Accepted solution]

@kari1282 , Try to get it created at source as a column, you can not use measure in a slicer,

You can have measures like

Switch(True() ,

search("Associate", Max(Table[Title]), ,0)>0 , "Associate", "Senior" )