Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
2 years ago
Solved

Create a group

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

Need Help
  • amitchandak's avatar
    amitchandak
    2 years ago

    Anonymous , 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" )

     

     

1 Reply

  • amitchandak's avatar
    amitchandak
    Super User
    2 years ago

    Anonymous , 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" )