Forum Discussion

prabhuk's avatar
prabhuk
Helper I
5 years ago
Solved

Group Customer

Hello! I have about 100 customers in my table from whcich i need to create a measure to select sepcific two customers rest of the customers grouped uder "all others". Example: Customer A and Custome...
Need Help
  • v-janeyg-msft's avatar
    v-janeyg-msft
    5 years ago

    hi， prabhuk 

     

    It’s my pleasure to answer for you.

    According to your description,If the original ‘customer’ column doesn't appear in your table, It's recommended to use a calculated column to display.

    Like this:

    Column = SWITCH (
    TRUE(),
    'Table'[Customer]="AA","A",
    'Table'[Customer]="BB","B",
    "All Others"
    )

    If it doesn’t solve your problem, please feel free to ask me.

     

    Best Regards

    Janey Guo

     

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

prabhuk's avatar
prabhuk
Helper I
5 years ago

Thanks,

 

When i select measure along with sale value ,it is relfecting as customerA not as Customer A and Customer B and all others . I have attached the File for your reference. Kindly help to have measure in row  as Customer A, Custome B and All others and Sales in Value column.

https://www.dropbox.com/s/ebdltaemwfbqg9l/prabhuk.pbix?dl=0

v-janeyg-msft's avatar
v-janeyg-msft
Community Support
5 years ago

hi， prabhuk 

 

It’s my pleasure to answer for you.

According to your description,If the original ‘customer’ column doesn't appear in your table, It's recommended to use a calculated column to display.

Like this:

Column = SWITCH (
    TRUE(),
    'Table'[Customer]="AA","A",
    'Table'[Customer]="BB","B",
    "All Others"
    )

If it doesn’t solve your problem, please feel free to ask me.

 

Best Regards

Janey Guo

 

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