Basket Type analysis

Hi Anonymous 

Here I have two ways to get the average.

Calculated column:

Avg = 
VAR _CountOrder =
    CALCULATE (
        DISTINCTCOUNT ( 'Table'[Sales_Order_ID] ),
        FILTER ( 'Table', 'Table'[SKU] = EARLIER ( 'Table'[SKU] ) )
    )
VAR _OrderT =
    SUMMARIZE (
        FILTER ( 'Table', 'Table'[SKU] = EARLIER ( 'Table'[SKU] ) ),
        'Table'[Sales_Order_ID]
    )
VAR _CountItem =
    CALCULATE (
        COUNT ( 'Table'[Line_Item_ID] ),
        FILTER ( 'Table', 'Table'[Sales_Order_ID] IN _OrderT )
    )
RETURN
    _CountItem / _CountOrder

Result is as below.

Measure:

M_Avg = 
VAR _CountOrder =
    CALCULATE (
        DISTINCTCOUNT ( 'Table'[Sales_Order_ID] ),
        FILTER ( ALL('Table'), 'Table'[SKU] = MAX('Table'[SKU] ) )
    )
VAR _OrderT =
    SUMMARIZE (
        FILTER (ALL( 'Table'), 'Table'[SKU] = MAX ( 'Table'[SKU] ) ),
        'Table'[Sales_Order_ID]
    )
VAR _CountItem =
    CALCULATE (
        COUNT ( 'Table'[Line_Item_ID] ),
        FILTER ( ALL('Table'), 'Table'[Sales_Order_ID] IN _OrderT )
    )
RETURN
    _CountItem / _CountOrder

Result is as below.

Best Regards,

Rico Zhou

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