DAX help

[prashantg364]

I have a data set as shown below.

Order ID	Order Message	Order Product Quantity	Order Engg Name	Order Category	Order Bucket	Date
217794857	DL_EE_T1_A	10	James	Poor Light		5-4-21
217794857	DL_EE_T1_A	10	James		HW issue	5-4-21
217794860	DL_EE_T1_B	8	Rozer	Poor average		5-5-21
217794860	DL_EE_T1_B	8	Rozer		Bulb issue	5-5-21
217794000	DL_EE_T1_C	20	Charlie	Poor tire		5-1-21
217794000	DL_EE_T1_C	20	Charlie		HW issue	5-1-21
217794100	DL_EE_T1_D	4	Beta	Poor color		5-7-21
217794100	DL_EE_T1_D	4	Beta		Quality issue	5-7-21

I want to summarize the above table and need output as shown below. Kindly Help

Order ID	Order Message	Order Product Quantity	Order Engg Name	Order Category	Order Bucket	Date
217794857	DL_EE_T1_A	10	James	Poor Light	HW issue	5-4-21
217794860	DL_EE_T1_B	8	Rozer	Poor average	Bulb issue	5-5-21
217794000	DL_EE_T1_C	20	Charlie	Poor tire	HW issue	5-1-21
217794100	DL_EE_T1_D	4	Beta	Poor color	Quality issue	5-7-21

[Anonymous]

Hi @prashantg364 

You can create a calculated table

Table 2 =
SUMMARIZE (
    'Table',
    [Order ID],
    [Order Message],
    'Table'[Order Product Quantity],
    [Order Engg Name],
    [Date],
    "Order Category",
        CALCULATE (
            MIN ( 'Table'[Order Category] ),
            'Table'[Order Category] <> BLANK ()
        ),
    "Order Bucket", CALCULATE ( MIN ( 'Table'[Order Bucket] ), 'Table'[Order Bucket] <> BLANK () )
)

Output

Best Regards!

Yolo Zhu

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