TopN dax function is not working

[Alex_Hasan]

Hello guys, This is the problem I'm having right now while extracting Top 10 customers. You see the image, it's not showing proper value. here is my dax function.

Top 10 customers =

                CALCULATE([Total Sales],

               TOPN( 10, DimCustomer, DimCustomer[FirstName], ASC))

[CNENFRNL]

Top 10 customers =
CALCULATE(
    [Total Sales],
    KEEPFILTERS(
        TOPN( 10, ALLSELECTED( DimCustomer[FirstName] ), DimCustomer[FirstName], ASC )
    )
)

[Alex_Hasan · Accepted solution]

I got the solution just now. In your coding, the  DimCustomer[FirstName]  has been mentioned two times. So I replaced one with [Total sales] and it's showing the top 10 that I wanted. 

Top 10 customers =
CALCULATE(
[Total Sales],
KEEPFILTERS(
TOPN( 10, ALLSELECTED( DimCustomer[FirstName] ), [Total sales], ASC )
)
) 

[Alex_Hasan]

Hi @CNENFRNL , thanks for your response. I tried with your function. It is showing this - 

I think the function was supposed to show this one with top 10. 

[KarinaUrtazu]

Para que muestre esos valores, cambia el ASC por DESC  y solo con eso debería ser suficiente