Switch Measure

[gauravnarchal]

I need help to create a switch true measure from the grouping that I have in the table.

For example

If (table 1 Groupcode) is Apple return apple else return others

[Anonymous · Accepted solution]

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.

[Greg_Deckler]

@gauravnarchal So like:

Measure =
  VAR __GroupCode = MAX('Table1'[Groupcode])
RETURN
  SWITCH(TRUE(),
    __GroupCode = "Apple","apple",
    "others"
  )

[gauravnarchal]

Hi @Greg_Deckler  I have tried the measure but it only gives me "Others" in the result. 

[Greg_Deckler]

@gauravnarchal Well, that is going to be either because you might have some trailing whitespace for the text or could be context of the visual. Without sample data and description of what you are really doing, going to be hard to pin down the cause.

Sorry, having trouble following, can you post sample data as text and expected output?
Not really enough information to go on, please first check if your issue is a common issue listed here: https://community.powerbi.com/t5/Community-Blog/Before-You-Post-Read-This/ba-p/1116882

Also, please see this post regarding How to Get Your Question Answered Quickly: https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490

The most important parts are:
1. Sample data as text, use the table tool in the editing bar
2. Expected output from sample data
3. Explanation in words of how to get from 1. to 2.

[gauravnarchal]

Hi @Greg_Deckler  - Yes i can see a whitespace coming. How can I get rid of this?

[Greg_Deckler]

@gauravnarchal In your query, you can use a Trim operation on the column (right-click, Transform, Trim).