Forum Discussion

Alex_Hasan's avatar
Alex_Hasan
Icon for Helper II rankHelper II
4 years ago
Solved

TopN dax function is not working

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 =           ...
TopN Customer
  • Alex_Hasan's avatar
    Alex_Hasan
    4 years ago

    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 )
    )
    ) 

CNENFRNL's avatar
CNENFRNL
Icon for Community Champion rankCommunity Champion
4 years ago
Top 10 customers =
CALCULATE(
    [Total Sales],
    KEEPFILTERS(
        TOPN( 10, ALLSELECTED( DimCustomer[FirstName] ), DimCustomer[FirstName], ASC )
    )
)
  • Alex_Hasan's avatar
    Alex_Hasan
    Icon for Helper II rankHelper II
    4 years ago

    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's avatar
      KarinaUrtazu
      Icon for Advocate II rankAdvocate II
      3 years ago

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

  • Alex_Hasan's avatar
    Alex_Hasan
    Icon for Helper II rankHelper II
    4 years ago

    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 )
    )
    )