Switch Measure

Hi gauravnarchal ,

I have created a simple, please refer to it to see if it helps you.

Create a measure.

Measure = 
SWITCH(TRUE(),MAX('Table 1'[Groupcode])="apple","apple","others")

Or a column.

Column =
SWITCH ( TRUE (), ( 'Table 1'[Groupcode] ) = "apple", "apple", "others" )

 And Greg_Deckler 's formula works well.

Measure 2 = 
  VAR __GroupCode = MAX('Table 1'[Groupcode])
RETURN
  SWITCH(TRUE(),
    __GroupCode = "apple","apple",
    "others"
  )

Or you can change it to a column.

Column 2 = 
  VAR __GroupCode = ('Table 1'[Groupcode])
RETURN
  SWITCH(TRUE(),
    __GroupCode = "apple","apple",
    "others"
  )

If I have misunderstood your meaning, please provide more details with your desired output and pbix file without privacy information.

Best Regards

Community Support Team _ Polly

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.