TOPN function with filter

[Talal141218]

Hello Community, 

I am trying to create a formula in TOPN to select Top 10 customers' sales

CALCULATE(Fact_SalesInvoiceLine[CM_SalesInvoiceLine_Amount_ExclAll_LCY],TOPN(10,VALUES(Dim_Customer[CustomerName]),Fact_SalesInvoiceLine[CM_SalesInvoiceLine_Amount_ExclAll_LCY]))

, but when i create it, show me all customers' sales but the total of sales is for Top 10 customers' name. Please let me know if you need more Info.

as below: 

Thanks in advance for your suggestions. 

[johnt75]

Try

Top Sales =
CALCULATE (
    [CM_SalesInvoiceLine_Amount_ExclAll_LCY],
    TOPN (
        10,
        ALLSELECTED ( Dim_Customer[CustomerName] ),
        [CM_SalesInvoiceLine_Amount_ExclAll_LCY]
    )
)

[Talal141218]

I got this, when i applicate your formula, Thanks for your interesting 

[johnt75 · Accepted solution]

How about

Top Sales =
VAR Top10 =
    TOPN (
        10,
        ALLSELECTED ( Dim_Customer[CustomerName] ),
        [CM_SalesInvoiceLine_Amount_ExclAll_LCY]
    )
RETURN
    CALCULATE ( [CM_SalesInvoiceLine_Amount_ExclAll_LCY], KEEPFILTERS( Top10 ) )

[Talal141218]

Sorry, the same result 

[johnt75]

I've edited my post to add KEEPFILTERS, I think that should do it.