cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
sumit5283 Frequent Visitor
Frequent Visitor

How to bucket a column values(Text) through measure

I want to create a custom column through measure only. As shown in the below table I have a column (Region) basis i want to create Custom Region.

 

Can someone help on this. 

 

RegionCustom Region
AfricaMECAA
South AfricaMECAA
MENAMECAA
MECAAMECAA
AmericasAmericas
AMEAmericas
EuropeEurope
LondonEurope
AsiaAPAC
APACAPAC
IndiaIndia
6 REPLIES 6
Community Support Team
Community Support Team

Re: How to bucket a column values(Text) through measure

Hi @sumit5283,

 

If you already have a lookup table which uniquely shows the mapping relation between Region and its corresponding Custom Region type, you can establish a relationship between two tables based on [Region] and create a measure similar to:

Measure = MAX(LookUpTable[Custom Region])

Regards,

Yuliana Gu

Community Support Team _ Yuliana Gu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
sumit5283 Frequent Visitor
Frequent Visitor

Re: How to bucket a column values(Text) through measure

Hi Yulina,

 

Thanks for your inputs. However i am not using any Lookup table here. There is only one table which is having one column. Since I am unsing the live connection I cannot create custom columns or Lookup table. I have to group that column with measure only. Can you or Someone will help here.  I tried with

Measure(Custom Region) - If(Values(Table[Region]="Africa") || Values(Table[Region]="MENA"),"MECAA")

but gettong the error.

 

Please let me know if you have any solution on this.

Community Support Team
Community Support Team

Re: How to bucket a column values(Text) through measure

Hi @sumit5283,

 

Please modify the measure formula:

Measure(Custom Region)= If(SELECTEDVALUE(Table[Region]="Africa")||SELECTEDVALUE(Table[Region]="MENA"),"MECAA")

 

Best regards,

Yuliana Gu

Community Support Team _ Yuliana Gu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
sumit5283 Frequent Visitor
Frequent Visitor

Re: How to bucket a column values(Text) through measure

Hi Yuliana,

 

I tried but it is not working. Please let me know the other options.

Highlighted
sumit5283 Frequent Visitor
Frequent Visitor

Re: How to bucket a column values(Text) through measure

Hi Yuliana,

 

Are you still working on this. Still waiting for the resolution

Community Support Team
Community Support Team

Re: How to bucket a column values(Text) through measure

Hi @sumit5283,

 

Did you get any error message with above measure formula?

 

Regards,

Yuliana Gu

Community Support Team _ Yuliana Gu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.