Forum Discussion
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 = ...
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 )
)
)
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.
Para que muestre esos valores, cambia el ASC por DESC y solo con eso deberÃa ser suficiente