Forum Discussion

Alex_Hasan's avatar
Alex_Hasan
Helper 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 =
                CALCULATE([Total Sales],
               TOPN( 10, DimCustomer, DimCustomer[FirstName], ASC))
 
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 )
    )
    ) 

4 Replies

  • CNENFRNL's avatar
    CNENFRNL
    Community 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
      Helper 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
        Advocate 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
      Helper 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 )
      )
      )