cancel
Showing results for
Did you mean:
Helper I

## Dynamic text for TopN

Hello Folks!

I would like to know if it's possible to add a dynamic text box to tell me which are the most sold product when I select a customer?

Many thanks,

Renata

2 ACCEPTED SOLUTIONS
Solution Sage

Try using this measure:

Top10 = SumX(TOPN(10,SUMMARIZE(ProductTable,ProductTable[Product Name],"UnitsSale",[TotalSales]),[UnitsSale],DESC),[TotalSales])

Put this measure in the values.

If this doesn't work, try:

Top10 = TOPN(10,TOPN
(10,
SUMMARIZE(
ProductTable
,ProductTable[ProductName],"TotalUnits", SUM(ProductTable[UnitsSold])
),"TotalUnits",DESC))

Additionally, make sure the customer and the product information is related in some way, eiether using a relationship or is part of the same table.

Community Support

Try this:

Top 10 Products =
CONCATENATEX (
TOPN (
10,
SUMMARIZE ( 'Table', 'Table'[Product], "Sales_", [Your Sales Measure] ),
[Sales_], DESC
),
[Product],
", "
)

Best Regards,

Icey

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

8 REPLIES 8
Community Support

Try this:

Top 10 Products =
CONCATENATEX (
TOPN (
10,
SUMMARIZE ( 'Table', 'Table'[Product], "Sales_", [Your Sales Measure] ),
[Sales_], DESC
),
[Product],
", "
)

Best Regards,

Icey

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Helper I

Hi, thanks for your reply guys, and sorry if I wasn't clear. What I want here is: when I select the customer on the slicer, I would like to have a text listing the Top10 products based on units. Many thanks!

Solution Sage

Try using this measure:

Top10 = SumX(TOPN(10,SUMMARIZE(ProductTable,ProductTable[Product Name],"UnitsSale",[TotalSales]),[UnitsSale],DESC),[TotalSales])

Put this measure in the values.

If this doesn't work, try:

Top10 = TOPN(10,TOPN
(10,
SUMMARIZE(
ProductTable
,ProductTable[ProductName],"TotalUnits", SUM(ProductTable[UnitsSold])
),"TotalUnits",DESC))

Additionally, make sure the customer and the product information is related in some way, eiether using a relationship or is part of the same table.

Frequent Visitor

I used the second and works pretyr good.

Solution Sage

Thanks.

Can you please mark the relevant one as an accepted solution?

Frequent Visitor

How do I do that? I can't see this option.

Super User II

@RenataOGardner A Text box wont help you in this case. Instead, you should you Card Visuals and put the displaying field on that card.

Don't forget to give thumbs up and accept this as a solution if it helped you!!!

Please take a quick glance at newly created dashboards : Restaurant Management Dashboard , HR Analytics Report , Hotel Management Report, and Sales Analysis Report
Solution Sage

Hello,

Try creating a measure similar to below and use it in a card visual:

BestSellingProduct = MAXX(SUMMARIZE(ProductTable,ProductTable[ProductName],"Sales",[TotalSalesMeasure]),ProductTable[ProductName])

Announcements

#### Microsoft Business Applications Summit sessions

On-demand access to all the great content presented by the product teams and community members! #MSBizAppsSummit #CommunityRocks