Show one value from measure, filtered by different measure

[PKPK90]

Hi,
I'am working on ABC analysis, and I want to create/format Scatter chart based on measures. I want to add X-Axis line that will correspond to minimum value from SalesAmount where RunningSales% is less than 70%. Only one number.

In this case it should show ~18$.

I have a measure to get RunningSales%, and also I have a measure with SalesAmount per Item.

M_RunningSales% =

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

        CurrentCumulatedPct

)

M_Sales Amount = SUMX(CustomerOrders,CustomerOrders[QtyOrdered] * CustomerOrders[UnitPrice])

Any suggestions? Thank you in advance!

[v-yangliu-msft]

Hi  @PKPK90 ,

Here are the steps you can follow：

1. Create measure.

Measure =
MAXX(
    FILTER(ALLSELECTED('Table'),
    'Table'[RunningToal%]=
MAXX(
    FILTER(ALLSELECTED('Table'),'Table'[RunningToal%]<=0.7),[RunningToal%])),'Table'[TotalSales])

2. Result:

If I have misunderstood your meaning, Can you express the result in the form of a picture or please provide your pbix file without privacy information and desired output, we can help you better.

Best Regards,

Liu Yang

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

[PKPK90]

Yes, thank you, it is exactly what I was looking for but it is not working for some reason on my report. It is showing blanks. 
I think it can be because I have a measure for TotalSales (because there is more lines for one item, so I need to group/sum them before showing in the table) = 

M_Sales Amount = SUMX(CustomerOrders,CustomerOrders[QtyOrdered] * CustomerOrders[UnitPrice])

Second thing is, I have Item master table which is used to filter table. You can see it on my M_RunningSales% measure.