rankx for product

[emveha]

Hi

Want to create a measure with the TOPX items based on the invoiced quantity, as an example; product 1 = invoiced qty=10, prod 2=inv. qty 40, prod 3=inv qty 35. So based on what i want to see, this should be the result:

Prod 2=1

Prod3=2

Prod1=3

My formula looks likes this: Top N = RANKX(ALL('Product'[Product Code]); SUMX(RELATEDTABLE(Sales); Sales[QuantityN])) 

Besides the fact that it takes a long time to execute this script, i don t get the result as i expected, in fact i only 1 as a result.

So my result looks like this: prod 1=invoiced qty=40, top N=1, prod2=inv qty=10, top N=1, prod3 =inv qty=500 top N=1.....

Any ideas what i am doing wrong and what needs to be changed...

thanks a lot!!

M

[emveha · Accepted solution]

found the issue, and it works now (in my query i had product plus product name but in my topN script I forgot to add the product name....)