Getting the product sales by month for TOP N customers

[sekinod]

I am able to get the TOP N customer sales as an above table  with following command

new top = 
VAR RankingDimension = VALUES(Customers[Customer Name])
return
CALCULATE([Total Sales],
FILTER(RankingDimension,RANKX(ALL(Customers[Customer Name]),[Total Sales],,DESC)<=[selected N]))

but when I use it with month or product name I get the following table

Total is shown is here correct but values are not matching. Please help me with this

Thank you in advance

[wdx223_Daniel · Accepted solution]

@sekinod when you put month or product in the rows, then the second parameter of RANKX, [total sales], will bring in these filter context into the calculation. so in each row it  calculates topn in that month or product. 

new top = 
VAR RankingDimension = VALUES(Customers[Customer Name])
return
CALCULATE([Total Sales],
FILTER(RankingDimension,RANKX(ALL(Customers[Customer Name]),VAR c=Customers[Customer Name] RETURN CALCULATE([Total Sales],ALLSELECT(),Customers[Customer Name]=c),,DESC)<=[selected N]))

[sekinod]

Much appreiciated for your help. 

If it is not trouble could you please explain your code.

[wdx223_Daniel]

@sekinod depending on the data what you show, i think you want RANKX only considers the Customer Name, ingoring whatever other filter context. so,  i used a allselect() to remove all the filters in the visual, then used Customers[Customer Name]=c to reapply the filter on Customer Name.

[mahoneypat]

Not sure but try using VALUES in your RANKX instead of ALL (or re-use your rankingdimension variable there).

Regards,

Pat