Use measure in the row

[PKPK90]

I have created a measure that is grouping Items into ABC category, I also have a table that can show Item with new ABC Category, but next step is to show Total sales and count of items per ABC group in matrix table, how can resolve it?

Here is my measure 

M_ABC_SalesAmount =

IF (

    HASONEVALUE ( Items[Item] ),

    VAR SalesByProduct =

        CALCULATETABLE (

            ADDCOLUMNS (

                SUMMARIZE ( CustomerOrders, CustomerOrders[SiteItem] ),

                "@ProdSales", [M_Sales Amount]

            ),

            ALLSELECTED ( Items )

        )

    VAR AllSales =

        CALCULATE (

            [M_Sales Amount],

            ALLSELECTED ( Items)

        )

    VAR CurrentSalesAmt = [M_Sales Amount]

    VAR CumulatedSales =

        FILTER (

            SalesByProduct,

            [@ProdSales] >= CurrentSalesAmt

        )

    VAR CumulatedSalesAmount =

        SUMX (

            CumulatedSales,

            [@ProdSales]

        )

    VAR CurrentCumulatedPct =

        DIVIDE (

            CumulatedSalesAmount,

            AllSales

        )

    VAR Result =

        SWITCH (

            TRUE,

            ISBLANK ( CurrentCumulatedPct ), BLANK (),

            CurrentCumulatedPct <= 0.7, "A",

            CurrentCumulatedPct <= 0.9, "B",

            "C"

        )

    RETURN

        Result

)

What I want to show in the next step

Matrix:

A	B	C
70000$	20000$	10000$
25Items	500Items	1500items

[Anonymous]

HI @PKPK90,

Current measure expression not able to be used as category or axis fields to expand the calculation ranges.
I'd like to suggest you create a new table with correspond segmentation and types to use on matrix column field. Then you can use measure formula to show different result based on current category values.

Regards,

Xiaoxin Sheng