Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Group by the multiple values in one column

Hello. I have a some columns in my file that correspond to customer's orders: order date, payment date, Number of order, product typology, etc.  The behavior of the file is: when some customer order ...
Need Help
amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
6 years ago

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