Merging same row data in column into one

[Mkhubaib]

So i am having a trouble here. Below mentioned is the sample data

Here in LineItemCategory column Luxury Pret and Luxe Pret are same. So for visulaization i want to merge both of these and find the sum of LineItemQTY. Can any body help me with this.

When i visualize the existing data i get both of these as seperate categories as shown bwlow:

So again i just want both Luxury Pret and Luxe pret as same and sum of there LineItemQTY in visualization.

Thanks

[az38 · Accepted solution]

@Mkhubaib 

Create a calculated column like

Category = 
IF(Table[LineItemCategory] = "Luxe Pret", "Luxury Pret", Table[LineItemCategory])

and use this new column for visual as a category 

[amitchandak]

@Mkhubaib , you need to do binning and segmentation

refer

https://www.daxpatterns.com/dynamic-segmentation/
https://www.daxpatterns.com/static-segmentation/
https://www.poweredsolutions.co/2020/01/11/dax-vs-power-query-static-segmentation-in-power-bi-dax-po...
https://radacad.com/grouping-and-binning-step-towards-better-data-visualization