Forum Discussion
Group by the multiple values in one column
Anonymous , You can count orders like this
Single Item orders = countx(filter(Summarize(Table,Table[Num_Order], "_1", count(Table[SKU])), [_1]=1),[Num_Order])
multiple Item orders = countx(filter(Summarize(Table,Table[Num_Order], "_1", count(Table[SKU])), [_1]>1),[Num_Order])Two have these as bucket values or dimension value you need have brining or segmentation
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-power-query/
https://radacad.com/grouping-and-binning-step-towards-better-data-visualization
Community ChampionAnonymous Seems like a matrix visualization with multiple columns in the Rows field area?
It is a matrix with multiple column fields that correspond to order's fields like number of order, payment date, shipment status, Sku number, and SKU typology.
Each row correspond to each order's entry. That means that if a client orders only one item, it corresponds to his order but if a client orders 4 itens, the 4 rows correspond to client's order.
I want to group by by number of order to understand if a customer orders one item or more than one. The problem is that I want to understand which sku typologies clients order and I can't group by different values (a client can order different itens' typologies like socks and a tshirt, that corresponds to different numbers (23 and 45 for example).