Forum Discussion
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.
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 In your query, you can use a Trim operation on the column (right-click, Transform, Trim).