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 )
)
)
Top 10 customers =
CALCULATE(
[Total Sales],
KEEPFILTERS(
TOPN( 10, ALLSELECTED( DimCustomer[FirstName] ), DimCustomer[FirstName], ASC )
)
)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 )
)
)