topic Re: TopN dax function is not working in DAX Commands and Tips

TopN dax function is not working

Alex_Hasan — Thu, 12 May 2022 15:40:12 GMT

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

Re: TopN dax function is not working

CNENFRNL — Thu, 12 May 2022 16:24:50 GMT

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

Re: TopN dax function is not working

Alex_Hasan — Thu, 12 May 2022 16:37:17 GMT

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.

Re: TopN dax function is not working

Alex_Hasan — Thu, 12 May 2022 17:27:18 GMT

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

Re: TopN dax function is not working

KarinaUrtazu — Mon, 27 Mar 2023 13:48:23 GMT

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