Microsoft Fabric Community Conference 2025, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount.
Register nowThe Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.
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
Solved! Go to Solution.
@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" )
@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" )