Forum Discussion
TOP N
Hi mnarmeen,
>>The id e,g 878 is repeating again and again
TOPN function returns the top N rows of the specified table. When you use [itemQty] to filter the report, it returns all the top 5 rows based on [itemQty], it did't care the customer ID if is same.
For your requirement, please create a measure get the sum of each customers.sum=CALCULATE(SUM(entries[itemQty]),ALLEXCEPT(Custom, Custom[ID]))
Then create another measure used to filter the top 5 customers.RANK=RANKX(ALLSELECTED(Custom),[sum],,DESC,Dense)
Finally, create a table visual, select the [ID], measure [sum] as value levels. Add the measure [RANK] as Visual level Filters, let the RANK value is less than or equals to 5, please review the following screenshot.
Best Regards,
AngeliaThankyou so much for the help. However I got it resolved by making a measure
sumItemQty=sum(enteries[itemQty])
and then used it in CustomerID filtering topN.
Yet, I dont know why it didnt work by simply puting ItemQty column in CustomerID topN and using SUM in aggregation.
The id e,g 878 is repeating again and again, however it must show only 19 .
In what table is the "ItemQty" column?
It's important that you use columns from the same table when making the TOPN.
Hi mnarmeen,
Have you resolved your issue? Please mark the helpful or right reply as answer, so more people will benefit from here.
Best Regards,
AngeliaThankyou so much for the help. However I got it resolved by making a measure
sumItemQty=sum(enteries[itemQty])
and then used it in CustomerID filtering topN.
Yet, I dont know why it didnt work by simply puting ItemQty column in CustomerID topN and using SUM in aggregation.